Wednesday, March 21, 2012

referencing to a function..

I was created a function named aa.

It is possible to reference to it without using the dbo. prnounce ?

eg: select aa(), not select dbo.aa()

thanks,

ViktorThe owner name is required for scalar UDFs but not for table-valued UDFs.
Otherwise it could be difficult to identify from the syntax that a scalar
UDF was being referenced.

--
David Portas
SQL Server MVP
--

No comments:

Post a Comment