SQL Server Errors or Failures from Error: 10723 to Error: 10742

SQLServerF1

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

Error: 10723, Severity: 15,
In a MERGE statement, a variable cannot be set to a column and expression in the same assignment in the SET clause of an UPDATE action. Assignments of the form ‘SET @variable = column = expression’ are not valid in the SET clause of an UPDATE action in a

Error: 10724, Severity: 15,
The FORCESEEK hint is not allowed for target tables of INSERT, UPDATE, or DELETE statements.

Error: 10725, Severity: 15,
Cannot use the VARYING option in a DECLARE, CREATE AGGREGATE or CREATE FUNCTION statement.

Error: 10726, Severity: 15,
User defined aggregates do not support default parameters.

Error: 10727, Severity: 15,
A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed on either side of a JOIN or APPLY operator.

Error: 10728, Severity: 15,
A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed as the table source of a PIVOT or UNPIVOT operator.

Error: 10729, Severity: 15,
A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in a SELECT statement that is not the immediate source of rows for an INSERT statement.

Error: 10730, Severity: 15,
A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in the FROM clause of an UPDATE or DELETE statement.

Error: 10731, Severity: 15,
A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed inside another nested INSERT, UPDATE, DELETE, or MERGE statement.

Error: 10732, Severity: 15,
A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed on either side of a UNION, INTERSECT, or EXCEPT operator.

Error: 10733, Severity: 15,
A nested INSERT, UPDATE, DELETE, or MERGE statement is not allowed in the USING clause of a MERGE statement.

Error: 10734, Severity: 16,
Variable assignment is not allowed in a statement containing a top level UNION, INTERSECT or EXCEPT operator.

Error: 10735, Severity: 15,
Incorrect WHERE clause for filtered %S_MSG ‘%.*ls’ on table ‘%.*ls’.

Error: 10736, Severity: 15,
A full-text stoplist statement must be terminated by a semi-colon (;).

Error: 10737, Severity: 15,
In an ALTR TABLE REBUILD or ALTER INDEX REBUILD statement, when a partition is specified in a DATA_COMPRESSION clause, PARTITION=ALL must be specified. The PARTITION=ALL clause is used to reinforce that all partitions of the table or index will be rebuil

Error: 10738, Severity: 15,
The number of row value expressions in the INSERT statement exceeds the maximum allowed number of %d row values.

Error: 10739, Severity: 15,
The insert column list used in the MERGE statement cannot contain multi-part identifiers. Use single part identifiers instead.

Error: 10740, Severity: 15,
A search property list statement must end with a semicolon (;).

Error: 10741, Severity: 15,
A TOP can not be used in the same query or sub-query as a OFFSET.

Error: 10742, Severity: 15,
The offset specified in a OFFSET clause may not be negative.

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 *