SQL Server Errors

%sOnly ‘http://www.w3.org/2001/XMLSchema#boolean?’ or ‘node()*’ expressions allowed in conditions and with logical operators, found ‘%ls’

Error Message: Msg 2204, Level 16, State 1, Line 6 %sOnly ‘http://www.w3.org/2001/XMLSchema#boolean?’ or ‘node()*’ expressions allowed in conditions and with logical operators, found ‘%ls’ Severity level: 16. Description: This error message appears when in an XQuery a non-boolean or node() expression is found in a condition or logical expression. Consequences: The T-SQL statement can be […]

XQuery: Unable to resolve sql:variable(‘%.*ls’). The variable must be declared as a scalar TSQL variable.

Error Message: Msg 9501, Level 16, State 2, Line 4 XQuery: Unable to resolve sql:variable(‘%.*ls’). The variable must be declared as a scalar TSQL variable. Severity level: 16. Description: This error message appears when in an XQuery a variable cannot be resolved to a valid TSQL variable. Consequences: The T-SQL statement can be parsed, but […]

%sSyntax error near ‘%ls’, expected ‘%ls’.

Error Message: Msg 9303, Level 16, State 1, Line 7 %sSyntax error near ‘%ls’, expected ‘%ls’. Severity level: 16. Description: This error message appears when in an XQuery a syntax error is encountered. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the Severity level 16 are generated […]

%sThe name “%ls” has already been defined.

Error Message: Msg 2230, Level 16, State 1, Line 5 %sThe name “%ls” has already been defined. Severity level: 16. Description: This error message appears when in an XQuery a name is defined more than once. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the Severity level […]

%sThere are not enough actual arguments in the call to function “%ls”.

Error Message: Msg 2236, Level 16, State 1, Line 7 %sThere are not enough actual arguments in the call to function “%ls”. Severity level: 16. Description: This error message appears when in an XQuery not the required number of arguments is supplied for a particular function. Consequences: The T-SQL statement can be parsed, but causes […]

%sResult of ‘%ls’ expression is statically ‘empty’

Error Message: Msg 2377, Level 16, State 1, Line 4 %sResult of ‘%ls’ expression is statically ‘empty’ Severity level: 16. Description: This error message appears when in an Xquery the result of a for expression is statically empty. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the […]

%sVariable expected: ‘$name’

Error Message: Msg 2241, Level 16, State 1, Line 6 %sVariable expected: ‘$name’ Severity level: 16. Description: This error message appears when in an Xquery a variable was expected, but not found. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the Severity level 16 are generated by […]

%sInvalid source character 0x%02x

Error Message: Msg 2333, Level 16, State 1, Line 4 %sInvalid source character 0x%02x Severity level: 16. Description: This error message appears when in an XQuery an invalid source character was found. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the Severity level 16 are generated by […]

%sUnterminated string constant (started on line %u)

Error Message: Msg 2274, Level 16, State 1, Line 7 %sUnterminated string constant (started on line %u) Severity level: 16. Description: This error message appears when in an XQuery in unterminated string constant is encountered. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the Severity level 16 […]

%sHeterogeneous sequences are not allowed in ‘%ls’, found ‘%ls’ and ‘%ls’.

Error Message: Msg 9311, Level 16, State 1, Line 7 %sHeterogeneous sequences are not allowed in ‘%ls’, found ‘%ls’ and ‘%ls’. Severity level: 16. Description: This error message appears when in an XQuery non-homogeneous sequences are found. Consequences: The T-SQL statement can be parsed, but causes the error at runtime. Resolution: Errors of the Severity […]
Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |