SQL Server Errors Error or Failures 121 to Error 140


Below are some of the SQL Server Errors

Error: 121, Severity: 15,
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.

Error: 122, Severity: 15,
The %ls option is allowed only with %ls syntax.

Error: 123, Severity: 15,
Batch/procedure exceeds maximum length of %d characters.

Error: 124, Severity: 15,
CREATE PROCEDURE contains no statements.

Error: 125, Severity: 15,
Case expressions may only be nested to level %d.

Error: 126, Severity: 15,
Invalid pseudocolumn “%.*ls”.

Error: 127, Severity: 15,
A TOP N or FETCH rowcount value may not be negative.

Error: 128, Severity: 15,
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.

Error: 129, Severity: 15,
Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100.

Error: 130, Severity: 16,
Cannot perform an aggregate function on an expression containing an aggregate or a subquery.

Error: 131, Severity: 15,
The size (%d) given to the %S_MSG ‘%.*ls’ exceeds the maximum allowed for any data type (%d).

Error: 132, Severity: 15,
The label ‘%.*ls’ has already been declared. Label names must be unique within a query batch or stored procedure.

Error: 133, Severity: 15,
A GOTO statement references the label ‘%.*ls’ but the label has not been declared.

Error: 134, Severity: 15,
The variable name ‘%.*ls’ has already been declared. Variable names must be unique within a query batch or stored procedure.

Error: 135, Severity: 15,
Cannot use a BREAK statement outside the scope of a WHILE statement.

Error: 136, Severity: 15,
Cannot use a CONTINUE statement outside the scope of a WHILE statement.

Error: 137, Severity: 15,
Must declare the scalar variable “%.*ls”.

Error: 138, Severity: 15,
Correlation clause in a subquery not permitted.

Error: 139, Severity: 15,
Cannot assign a default value to a local variable.

Error: 140, Severity: 15,
Can only use IF UPDATE within a CREATE TRIGGER statement.

This is applicable on below versions of SQL Server

SQL Server 2005
SQL Server 2008 R2
SQL Server 2012
SQL Server 2014

Hope this was helpful.

SQLServerF1 Team
In-Depth Blogs on SQL Server, Information about SQL Server Conferences and Events, SQL Server Frequently asked questions, SQL Server Trainings.


Leave a Reply

Your email address will not be published. Required fields are marked *