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

Misc Javascript points

 Nodejs can support multithreading through use of promises _ is the numeric separator for javascript, that means the numbers 10_000, 11.23_0...