Skip to content

Syntax & Object Resolution errors

The parser or binder rejected the batch: syntax errors, unknown columns and objects, and missing parameters.

102 Incorrect syntax nearThe parser hit an unexpected token in your T-SQL. 156 Incorrect syntax near the keywordA reserved keyword was used or placed where it is not allowed. 207 Invalid column nameThe query references a column that does not exist in scope. 208 Invalid object nameThe table, view or object cannot be resolved. 201 Procedure or function expects a parameter which was not suppliedA required stored procedure parameter was not passed. 4104 The multi-part identifier could not be boundA table or alias prefix such as c.name does not match anything in the FROM clause. 3701 Cannot drop the object because it does not exist or no permissionA DROP failed on a missing object or without the right permission. 209 Ambiguous column nameAn unqualified column name matches more than one table in the query. 8120 Column is invalid in the select list because it is not in an aggregate or GROUP BYA grouped query selects a column that is neither grouped nor aggregated. 105 Unclosed quotation mark after the character stringA string literal was opened but never closed, usually followed by error 102. 137 Must declare the scalar variableA variable is used outside the batch or scope that declares it (GO, dynamic SQL). 2714 There is already an object named in the databaseA CREATE or SELECT INTO uses a name already taken by a table, constraint or module. 213 Column name or number of supplied values does not match table definitionAn INSERT without a column list supplies the wrong number of values. 544 Cannot insert explicit value for identity column when IDENTITY_INSERT is OFFAn INSERT lists the identity column but IDENTITY_INSERT is not ON in this scope. 8101 An explicit value for the identity column can only be specified with a column list and IDENTITY_INSERT ONAn INSERT without a column list supplies a value for the identity column. 2812 Could not find stored procedureEXEC names a procedure that does not exist in that schema or database. 134 The variable name has already been declaredThe same @variable is declared twice in one batch or procedure; loops and IF blocks are not separate scopes. 2760 The specified schema name either does not exist or you do not have permissionA CREATE or SELECT INTO names a schema that is missing or that the user cannot ALTER. 4121 Cannot find either column or the user-defined function or aggregateA prefix.Name(...) call matched no function in that schema: wrong schema, alias as prefix, or an xml method on text. 4145 An expression of non-boolean type specified where a condition is expectedWHERE, IF or CASE WHEN got a value such as a bit column instead of a comparison. 4902 Cannot find the object because it does not exist or you do not have permissionsALTER TABLE names a table that does not resolve: a typo, the wrong schema, or a temp table from an ended scope. 1919 Column is of a type that is invalid for use as a key column in an indexA (max), text or image column was used as an index or constraint key; use INCLUDE, a hash or prefix column, or a shorter type.
No errors in this category match your search. Search the whole library.

Other categories