SQL Server Errors or Failures from Error: 5310 to Error: 5331

SQLServerF1

 

Error: 5310, Severity: 16, Aggregates are not allowed in the VALUES list of an INSERT statement.
Error: 5311, Severity: 16, Invalid quote character ‘%lc’. A remote server or user command used an invalid quote character.
Error: 5312, Severity: 16, The input to the function ‘ntile’ cannot be bound.
Error: 5313, Severity: 16, Synonym ‘%.*ls’ refers to an invalid object.
Error: 5315, Severity: 16, The target of a MERGE statement cannot be a remote table, a remote view, or a view over remote tables.
Error: 5316, Severity: 16, The target ‘%.*ls’ of the MERGE statement has an INSTEAD OF trigger on some, but not all, of the actions specified in the MERGE statement. In a MERGE statement, if any action has an enabled INSTEAD OF trigger on the target, then all actions must have enab

Error: 5317, Severity: 16, The target of a MERGE statement cannot be a partitioned view.
Error: 5318, Severity: 16, In a MERGE statement, the source and target cannot have the same name or alias. Use different aliases for the source and target to ensure that they have unique names in the MERGE statement.
Error: 5319, Severity: 16, Aggregates are not allowed in a WHEN clause of a MERGE statement.
Error: 5321, Severity: 16, The ‘%ls’ function is not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
Error: 5322, Severity: 16, An aggregate function is not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
Error: 5323, Severity: 15, Subqueries are not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.

Error: 5324, Severity: 15, In a MERGE statement, a ‘%S_MSG’ clause with a search condition cannot appear after a ‘%S_MSG’ clause with no search condition.
Error: 5325, Severity: 15, The order of the data in the data file does not conform to the ORDER hint specified for the BULK rowset ‘%.*ls’. The order of the data must match the order specified in the ORDER hint for a BULK rowset. Update the ORDER hint to reflect the order in which
Error: 5326, Severity: 15, The data in the data file does not conform to the UNIQUE hint specified for the BULK rowset ‘%.*ls’. The data in the data file must be unique if the UNIQUE hint is specified for a BULK rowset. Remove the UNIQUE hint, or update the input data file to ensur
Error: 5327, Severity: 15, The column ‘%.*ls’ does not have a valid data type for the ORDER hint specified for data source ‘%.*ls’. The text, ntext, image, xml, varchar(max), nvarchar(max) and varbinary(max) data types cannot be used in the ORDER hint for a BULK rowset or CLR TVF.
Error: 5328, Severity: 15, Cannot insert explicit value for the identity column ‘%.*ls’ in the target table ‘%.*ls’ of the INSERT statement when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
Error: 5329, Severity: 15, Windowed functions are not allowed in the %S_MSG clause when the FROM clause contains a nested INSERT, UPDATE, DELETE, or MERGE statement.
Error: 5330, Severity: 16, Full-text predicates cannot appear in the OUTPUT clause.
Error: 5331, Severity: 16, Full-text predicates cannot appear in the %S_MSG clause 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 *