Error messages - TSQL Tutorial

The Transact SQL language show you various error messages when the code is written wrong, when we have incorrect syntax in the statement or when we don't have enough rights.

MsgLevelError messages
10915There are more columns in the INSERT statement than values specified in the VALUES clause
13715Must declare the scalar variable
15515Is not a recognized datepart option
17315The definition for column must include a data type
19515Is not a recognized built-in function name
20716Invalid column name
20616Operand type clash: int is incompatible with date
20816Invalid object name
24116Conversion failed when converting date and/or time from character string
24316Is not a defined system type
24516Conversion failed when converting the varchar value
34315Unknown object type used in a CREATE, DROP, or ALTER statement
51516Cannot insert the value NULL into column
54416Cannot insert explicit value for identity column in table
54716The INSERT statement conflicted with the FOREIGN KEY constraint
54716The DELETE statement conflicted with the REFERENCE constraint
100216Specified scale is invalid
177016Foreign key references invalid column in referenced table
177916Table already has a primary key defined on it
191116Column name does not exist in the target table or view
262714Violation of PRIMARY KEY constraint
270516Column names in each table must be unique
271416There is already an object named in the database
281216Could not find stored procedure
370111Cannot drop the table
372816Is not a constraint
451116Create View or Function failed because no column name was specified
811116Cannot define PRIMARY KEY constraint on nullable column in table
812016Column is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause
815216String or binary data would be truncated
1525016The database name component of the object qualifier must be the name of the current database
1525511No item by the name of '%' could be found in the current database.