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.
精彩评论