Is it possible to create a System UDF in SQL Server 2005
I saw that it is possible in SQL Serve开发者_如何学Gor 2000. I want to have a function(s) where I don't have to qualify it with an owner.
for instance fn_trim() instead of dbo.fn_trim()
Following on from Joe's answer
You can create a schema for your UDFs with CREATE SCHEMA (say "fn") so you could have fn.trim() rather than dbo.fn_trim().
This is not possible. The function has to be referenced as SchemaName.FunctionName.
As noted in the documentation:
Scalar-valued functions must be invoked by using at least the two-part name of the function.
加载中,请稍侯......
精彩评论