SQL Server Errors or Failures Error: 313 to Error: 333

SQLServerF1

 

Error: 313, severity: 16,
An insufficient number of arguments were supplied for the procedure or function %.*ls.

Error: 314, severity: 16,
Cannot use GROUP BY ALL with the special tables INSERTED or DELETED.

Error: 315, severity: 16,
Index “%.*ls” on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online.

Error: 316, severity: 16,
The index ID %d on table “%.*ls” (specified in the FROM clause) is disabled or resides in a filegroup which is not online.

Error: 317, severity: 16,
Table-valued function ‘%.*ls’ cannot have a column alias.

Error: 318, severity: 16,
The table (and its columns) returned by a table-valued method need to be aliased.

Error: 319, severity: 16,
Incorrect syntax near the keyword ‘with’. If this statement is a common table expression, an xmlnamespaces clause or a change tracking context clause, the previous statement must be terminated with a semicolon.

Error: 320, severity: 16,
The compile-time variable value for ‘%.*ls’ in the OPTIMIZE FOR clause must be a literal.

Error: 321, severity: 15,
“%.*ls” is not a recognized table hints option. If it is intended as a parameter to a table-valued function or to the CHANGETABLE function, ensure that your database compatibility mode is set to 90.

Error: 322, severity: 15,
The variable “%.*ls” is specified in the OPTIMIZE FOR clause, but is not used in the query.

Error: 324, severity: 15,
The ‘ALL’ version of the %.*ls operator is not supported.

Error: 325, severity: 15,
Incorrect syntax near ‘%.*ls’. You may need to set the compatibility level of the current database to a higher value to enable this feature. See help for the SET COMPATIBILITY_LEVEL option of ALTER DATABASE.

Error: 326, severity: 16,
Multi-part identifier ‘%.*ls’ is ambiguous. Both columns ‘%.*ls’ and ‘%.*ls’ exist.

Error: 327, severity: 16,
Function call ‘%.*ls’ is ambiguous: both a user-defined function and a method call with this name exist.

Error: 328, severity: 16,
A cursor plan could not be generated for the given statement because the textptr() function was used on a LOB column from one of the base tables.

Error: 329, severity: 16,
Each GROUP BY expression must contain at least one column reference.

Error: 330, severity: 15,
The target ‘%.*ls’ of the OUTPUT INTO clause cannot be a view or common table expression.

Error: 331, severity: 15,
The target table ‘%.*ls’ of the OUTPUT INTO clause cannot have any enabled triggers.

Error: 332, severity: 15,
The target table ‘%.*ls’ of the OUTPUT INTO clause cannot be on either side of a (primary key, foreign key) relationship. Found reference constraint ‘%ls’.

Error: 333, severity: 15,
The target table ‘%.*ls’ of the OUTPUT INTO clause cannot have any enabled check constraints or any enabled rules. Found check constraint or rule ‘%ls’.

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 *