Tuesday, July 5, 2011

SQL Server : Can a user-defined function return a text value ?

NO.

SQL user-defined functions cannot return text,ntext or image.


http://msdn.microsoft.com/en-us/library/aa258261(v=SQL.80).aspx
can be any of the scalar data types supported by SQL Server, except text, ntext, image, and timestamp.
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

rls

To enable row-level security (RLS) in MS SQL Server (2016 and later) , you need to define a security policy that uses a user-defined, inli...