开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜