USEFUL SITES :
Write for Us
Error Message: Msg 2395, Level 16, State 1, Line 7 %sThere is no function '%ls:%ls()'
Severity level: 16.
Description: This error message appears when you try to use an unknown XQuery function.
Consequences: The T-SQL statement can be parsed, but causes the error at runtime.
Resolution: Error of the Severity level 16 are generated by the user and are corrigible by the user. The statement cannot be run this way. The function you call must be a valid XQuery function. For further information, refer to the link in the error message text.
Versions: This error message was introduced with SQL Server 2005.
Example(s): DECLARE @xml xml; SET @xml = '<Result />'; SELECT @xml.query('for $a in(1, 2), $b in(3, 4) where $a < $b return SUM($a + $b)') as XML;
Remarks: In the above example we try to use the function SUM() in the XQuery. Because XQuery is case-sensitive, this is different from the function sum() and thus the error is raised.