Sql Error #139, Severity 15

Sql Error Number:139
Severity: 15

Description: Cannot assign a default value to a local variable.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #138, Severity 15

Sql Error Number:138
Severity: 15

Description: Correlation clause in a subquery not permitted.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #137, Severity 15

Sql Error Number:137
Severity: 15

Description: Must declare the scalar variable "%.*ls".

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #136, Severity 15

Sql Error Number:136
Severity: 15

Description: Cannot use a CONTINUE statement outside the scope of a WHILE statement.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #135, Severity 15

Sql Error Number:135
Severity: 15

Description: Cannot use a BREAK statement outside the scope of a WHILE statement.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #134, Severity 15

Sql Error Number:134
Severity: 15

Description: The variable name '%.*ls' has already been declared. Variable names must be unique within a query batch or stored procedure.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #133, Severity 15

Sql Error Number:133
Severity: 15

Description: A GOTO statement references the label '%.*ls' but the label has not been declared.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #132, Severity 15

Sql Error Number:132
Severity: 15

Description: The label '%.*ls' has already been declared. Label names must be unique within a query batch or stored procedure.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #131, Severity 15

Sql Error Number:131
Severity: 15

Description: The size (%d) given to the %S_MSG '%.*ls' exceeds the maximum allowed for any data type (%d).

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #130, Severity 16

Sql Error Number:130
Severity: 16

Description: Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #129, Severity 15

Sql Error Number:129
Severity: 15

Description: Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #128, Severity 15

Sql Error Number:128
Severity: 15

Description: The name "%.*s" is not permitted in this context. Valid expressions are constants, constant expressions, and (in some contexts) variables. Column names are not permitted.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #127, Severity 15

Sql Error Number:127
Severity: 15

Description: A TOP N value may not be negative.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #126, Severity 15

Sql Error Number:126
Severity: 15

Description: Invalid pseudocolumn "%.*ls".

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #125, Severity 15

Sql Error Number:125
Severity: 15

Description: Case expressions may only be nested to level %d.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #124, Severity 15

Sql Error Number:124
Severity: 15

Description: CREATE PROCEDURE contains no statements.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #123, Severity 15

Sql Error Number:123
Severity: 15

Description: Batch/procedure exceeds maximum length of %d characters.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #122, Severity 15

Sql Error Number:122
Severity: 15

Description: The %ls option is allowed only with %ls syntax.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #121, Severity 15

Sql Error Number:121
Severity: 15

Description: The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #120, Severity 15

Sql Error Number:120
Severity: 15

Description: The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT values must match the number of INSERT columns.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #119, Severity 15

Sql Error Number:119
Severity: 15

Description: Must pass parameter number %d and subsequent parameters as '@name = value'. After the form '@name = value' has been used, all subsequent parameters must be passed in the form '@name = value'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #117, Severity 15

Sql Error Number:117
Severity: 15

Description: The %S_MSG name '%.*ls' contains more than the maximum number of prefixes. The maximum is %d.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #116, Severity 15

Sql Error Number:116
Severity: 15

Description: Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #115, Severity 15

Sql Error Number:115
Severity: 15

Description: The FOR UPDATE clause is invalid for statements containing set operators.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #114, Severity 15

Sql Error Number:114
Severity: 15

Description: Browse mode is invalid for a statement that assigns values to a variable.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #113, Severity 15

Sql Error Number:113
Severity: 15

Description: Missing end comment mark '*/'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #112, Severity 15

Sql Error Number:112
Severity: 15

Description: Variables are not allowed in the %ls statement.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #111, Severity 15

Sql Error Number:111
Severity: 15

Description: '%ls' must be the first statement in a query batch.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #110, Severity 15

Sql Error Number:110
Severity: 15

Description: There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #109, Severity 15

Sql Error Number:109
Severity: 15

Description: There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #108, Severity 15

Sql Error Number:108
Severity: 15

Description: The ORDER BY position number %ld is out of range of the number of items in the select list.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #107, Severity 15

Sql Error Number:107
Severity: 15

Description: The column prefix '%.*ls' does not match with a table name or alias name used in the query.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #106, Severity 16

Sql Error Number:106
Severity: 16

Description: Too many table names in the query. The maximum allowable is %d.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #105, Severity 15

Sql Error Number:105
Severity: 15

Description: Unclosed quotation mark after the character string '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #104, Severity 15

Sql Error Number:104
Severity: 15

Description: ORDER BY items must appear in the select list if the statement contains a UNION, INTERSECT or EXCEPT operator.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #103, Severity 15

Sql Error Number:103
Severity: 15

Description: The %S_MSG that starts with '%.*ls' is too long. Maximum length is %d.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #102, Severity 15

Sql Error Number:102
Severity: 15

Description: Incorrect syntax near '%.*ls'.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #101, Severity 15

Sql Error Number:101
Severity: 15

Description: Query not allowed in WAITFOR.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

Sql Error #21, Severity 20

Sql Error Number:21
Severity: 20

Description: Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator.

Possibly related links:
There are no links yet!

User suggestions:
There are no user suggestions approved yet. Use the comments section to be the first!

What is this blog for?

In this blog you can share your experience with SQL exceptions. Soon we will add sections with all the Sql Exceptions.

Use the comments to share opinion and we will add your comment to the exception information (if we find it useful).