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)

DOCKER ARG instruction as opposed to ENV instruction

  In Docker, ARG and ENV are used to define environment variables. The ARG instruction defines variables that users can pass to the builder ...