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)

 using Microsoft.AspNetCore.Mvc; using System.Xml.Linq; using System.Xml.XPath; //<table class="common-table medium js-table js-stre...