SQL Server Errors or Failures from Error: 10700 to Error: 10722

SQLServerF1

You may receive various errors in SQL Server while working. Below are some of the SQL Server Errors from Error: 10700 to Error: 10722

Error: 10700, Severity: 16,
The table-valued parameter “%.*ls” is READONLY and cannot be modified.

Error: 10701, Severity: 15,
The READONLY option cannot be used in an EXECUTE or CREATE AGGREGATE statement.

Error: 10702, Severity: 15,
The WITH CUBE and WITH ROLLUP options are not permitted with a ROLLUP, CUBE, or GROUPING SETS specification.

Error: 10703, Severity: 15,
Too many grouping sets. The maximum number is %d.

Error: 10704, Severity: 15,
To rethrow an error, a THROW statement must be used inside a CATCH block. Insert the THROW statement inside a CATCH block, or add error parameters to the THROW statement.

Error: 10705, Severity: 15,
Subqueries are not allowed in the OUTPUT clause.

Error: 10706, Severity: 15,
Too many expressions are specified in the GROUP BY clause. The maximum number is %d when grouping sets are supplied.

Error: 10707, Severity: 15,
The CUBE() and ROLLUP() grouping constructs are not allowed in the current compatibility mode. They are only allowed in 100 mode or higher.

Error: 10708, Severity: 15,
DEFAULT is not allowed on the right hand side of “%.*ls”

Error: 10709, Severity: 15,
The number of columns for each row in a table value constructor must be the same.

Error: 10710, Severity: 15,
An action of type ‘%S_MSG’ is not allowed in the ‘WHEN NOT MATCHED’ clause of a MERGE statement.

Error: 10711, Severity: 15,
An action of type ‘INSERT’ is not allowed in the ‘%S_MSG’ clause of a MERGE statement.

Error: 10713, Severity: 15,
A MERGE statement must be terminated by a semi-colon (;).

Error: 10714, Severity: 15,
An action of type ‘%S_MSG’ cannot appear more than once in a ‘%S_MSG’ clause of a MERGE statement.

Error: 10716, Severity: 15,
A nested INSERT, UPDATE, DELETE, or MERGE statement must have an OUTPUT clause.

Error: 10717, Severity: 15,
The %S_MSG clause is not allowed when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.

Error: 10718, Severity: 15,
Query hints are not allowed in nested INSERT, UPDATE, DELETE, or MERGE statements.

Error: 10720, Severity: 15,
An OUTPUT INTO clause is not allowed in a nested INSERT, UPDATE, DELETE, or MERGE statement.

Error: 10721, Severity: 15,
The WHERE CURRENT OF clause is not allowed in a nested INSERT, UPDATE, DELETE, or MERGE statement.

Error: 10722, Severity: 15,
The DISTINCT keyword is not allowed when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE 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.

Thanks,
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 *