SQL Server Error Messages 201-314

201	Procedure '%.*ls' expects parameter '%.*ls', which was not supplied.
202	Invalid type '%s' for WAITFOR. Supported data types are CHAR/VARCHAR, NCHAR/NVARCHAR, and DATETIME. WAITFOR DELAY supports the INT and SMALLINT data types.
203	The name '%.*ls' is not a valid identifier.
204	Normalization error in node %ls.
205	All queries in an SQL statement containing a UNION operator must have an equal number of expressions in their target lists.
206	Operand type clash: %ls is incompatible with %ls
207	Invalid column name '%.*ls'.
208	Invalid object name '%.*ls'.
209	Ambiguous column name '%.*ls'.
210	Syntax error converting datetime from binary/varbinary string.
212	Expression result length exceeds the maximum. %d max, %d found.
213	Insert Error: Column name or number of supplied values does not match table definition.
214	Procedure expects parameter '%ls' of type '%ls'.
217	Maximum stored procedure, function, trigger, or view nesting level exceeded (limit %d).
220	Arithmetic overflow error for data type %ls, value = %ld.
221	FIPS Warning: Implicit conversion from %ls to %ls.
223	Object ID %ld specified as a default for table ID %ld, column ID %d is missing or not of type default.
224	Object ID %ld specified as a rule for table ID %ld, column ID %d is missing or not of type default.
226	%ls statement not allowed within multi-statement transaction.
229	%ls permission denied on object '%.*ls', database '%.*ls', owner '%.*ls'.
230	%ls permission denied on column '%.*ls' of object '%.*ls', database '%.*ls', owner '%.*ls'.
231	No such default. ID = %ld, database ID = %d.
232	Arithmetic overflow error for type %ls, value = %f.
233	The column '%.*ls' in table '%.*ls' cannot be null.
234	There is insufficient result space to convert a money value to %ls.
235	Cannot convert a char value to money. The char value has incorrect syntax.
236	The conversion from char data type to money resulted in a money overflow error.
237	There is insufficient result space to convert a money value to %ls.
238	There is insufficient result space to convert the %ls value (= %d) to the money data type.
241	Syntax error converting datetime from character string.
242	The conversion of a char data type to a datetime data type resulted in an out-of-range datetime value.
243	Type %.*ls is not a defined system type.
244	The conversion of the %ls value '%.*ls' overflowed an %hs column. Use a larger integer column.
245	Syntax error converting the %ls value '%.*ls' to a column of data type %ls.
248	The conversion of the %ls value '%.*ls' overflowed an int column. Maximum integer value exceeded.
251	Could not allocate ancillary table for query optimization. Maximum number of tables in a query (%d) exceeded.
256	The data type %ls is invalid for the %ls function. Allowed types are: char/varchar, nchar/nvarchar, and binary/varbinary.
257	Implicit conversion from data type %ls to %ls is not allowed. Use the CONVERT function to run this query.
259	Ad hoc updates to system catalogs are not enabled. The system administrator must reconfigure SQL Server to allow this.
260	Disallowed implicit conversion from data type %ls to data type %ls, table '%.*ls', column '%.*ls'. Use the CONVERT function to run this query.
261	'%.*ls' is not a recognized function.
262	%ls permission denied in database '%.*ls'.
263	Must specify table to select from.
264	Column name '%.*ls' appears more than once in the result column list.
266	Transaction count after EXECUTE indicates that a COMMIT or ROLLBACK TRANSACTION statement is missing. Previous count = %ld, current count = %ld.
267	Object '%.*ls' cannot be found.
268	Cannot run SELECT INTO in this database. The database owner must run sp_dboption to enable this option.
270	Object '%.*ls' cannot be modified.
271	Column '%.*ls' cannot be modified because it is a computed column.
272	Cannot update a timestamp column.
273	Cannot insert a non-null value into a timestamp column. Use INSERT with a column list or with a default of NULL for the timestamp column.
278	The text, ntext, and image data types cannot be used in a GROUP BY clause.
279	The text, ntext, and image data types are invalid in this subquery or aggregate expression.
280	Only text, ntext, and image columns are valid with the TEXTPTR function.
281	%d is not a valid style number when converting from %ls to a character string.
282	The '%.*ls' procedure attempted to return a status of NULL, which is not allowed. A status of 0 will be returned instead.
283	READTEXT cannot be used on inserted or deleted tables within an INSTEAD OF trigger.
284	Rules cannot be bound to text, ntext, or image data types.
285	The READTEXT, WRITETEXT, and UPDATETEXT statements cannot be used with views or functions.
286	The logical tables INSERTED and DELETED cannot be updated.
287	The %ls statement is not allowed within a trigger.
288	The PATINDEX function operates on char, nchar, varchar, nvarchar, text, and ntext data types only.
291	CAST or CONVERT: invalid attributes specified for type '%.*ls'
292	There is insufficient result space to convert a smallmoney value to %ls.
293	Cannot convert char value to smallmoney. The char value has incorrect syntax.
294	The conversion from char data type to smallmoney data type resulted in a smallmoney overflow error.
295	Syntax error converting character string to smalldatetime data type.
296	The conversion of char data type to smalldatetime data type resulted in an out-of-range smalldatetime value.
298	The conversion from datetime data type to smalldatetime data type resulted in a smalldatetime overflow error.
299	The DATEADD function was called with bad type %ls.
301	Query contains an outer-join request that is not permitted.
303	The table '%.*ls' is an inner member of an outer-join clause. This is not allowed if the table also participates in a regular join clause.
306	The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
307	Index ID %d on table '%.*ls' (specified in the FROM clause) does not exist.
308	Index '%.*ls' on table '%.*ls' (specified in the FROM clause) does not exist.
311	Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.
312	Cannot reference text, ntext, or image columns in a filter stored procedure.
313	An insufficient number of arguments were supplied for the procedure or function %.*ls.
314	Cannot use GROUP BY ALL with the special tables INSERTED or DELETED.

An INSERT statement cannot contain a SELECT statement that assigns values to a variable

Server: Msg 199, Level 15, State 1, Line 1
An INSERT statement cannot contain a SELECT statement
that assigns values to a variable.

This is the Error message which we generally encounter while writing the insert statement integrated with select statement.

For example check below code..

INSERT INTO [dbo].[Employee] ( [EmployeeName], [Address], [City], [State], [ZIPCode] )
SELECT TOP 1 @EmployeeName = [EmployeeName], @Address = [Address], @City = [City],
             @StateCode = [State], @ZIPCode = [ZIPCode]
FROM [dbo].[Employee]
WHERE [State] = 'HR'

In this same time you are assigning while inserting and it will throw Error.

Reason : So  now you were wondering the why this is happening. SQL Server generates a single query execution plan for a query batch. so if you notice above query you will be able to identify that variable is assigning value which are not available i.e. its for executing this there should be two plan one before assign the value other after assigning value but in this syntax its not happening thats why its throwing error.

Solution: do both operation in different query. First assign then insert.

SQL Server Error Message - Errors 1 to 200

1	Version date of last upgrade: 10/11/90
21	Warning: Fatal error %d occurred at %S_DATE. Note the error and time, and contact your system administrator.
102	Incorrect syntax near '%.*ls'.
103	The %S_MSG that starts with '%.*ls' is too long. Maximum length is %d.
104	ORDER BY items must appear in the select list if the statement contains a UNION operator.
105	Unclosed quotation mark before the character string '%.*ls'.
106	Too many table names in the query. The maximum allowable is %d.
107	The column prefix '%.*ls' does not match with a table name or alias name used in the query.
108	The ORDER BY position number %ld is out of range of the number of items in the select list.
109	There are more columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
110	There are fewer columns in the INSERT statement than values specified in the VALUES clause. The number of values in the VALUES clause must match the number of columns specified in the INSERT statement.
111	'%ls' must be the first statement in a query batch.
112	Variables are not allowed in the %ls statement.
113	Missing end comment mark '*/'.
114	Browse mode is invalid for a statement that assigns values to a variable.
116	Only one expression can be specified in the select list when the subquery is not introduced with EXISTS.
117	The %S_MSG name '%.*ls' contains more than the maximum number of prefixes. The maximum is %d.
118	Only members of the sysadmin role can specify the %ls option for the %ls statement.
119	Must pass parameter number %d and subsequent parameters as '@name = value'. After the form '@name = value' has been used, all subsequent parameters must be passed in the form '@name = value'.
120	The select list for the INSERT statement contains fewer items than the insert list. The number of SELECT values must match the number of INSERT columns.
121	The select list for the INSERT statement contains more items than the insert list. The number of SELECT values must match the number of INSERT columns.
122	The %ls option is allowed only with %ls syntax.
123	Batch/procedure exceeds maximum length of %d characters.
124	CREATE PROCEDURE contains no statements.
125	Case expressions may only be nested to level %d.
128	The name '%.*ls' is not permitted in this context. Only constants, expressions, or variables allowed here. Column names are not permitted.
129	Fillfactor %d is not a valid percentage; fillfactor must be between 1 and 100.
130	Cannot perform an aggregate function on an expression containing an aggregate or a subquery.
131	The size (%d) given to the %S_MSG '%.*ls' exceeds the maximum allowed for any data type (%d).
132	The label '%.*ls' has already been declared. Label names must be unique within a query batch or stored procedure.
133	A GOTO statement references the label '%.*ls' but the label has not been declared.
134	The variable name '%.*ls' has already been declared. Variable names must be unique within a query batch or stored procedure.
135	Cannot use a BREAK statement outside the scope of a WHILE statement.
136	Cannot use a CONTINUE statement outside the scope of a WHILE statement.
137	Must declare the variable '%.*ls'.
138	Correlation clause in a subquery not permitted.
139	Cannot assign a default value to a local variable.
140	Can only use IF UPDATE within a CREATE TRIGGER statement.
141	A SELECT statement that assigns a value to a variable must not be combined with data-retrieval operations.
142	Incorrect syntax for definition of the '%ls' constraint.
143	A COMPUTE BY item was not found in the order by list. All expressions in the compute by list must also be present in the order by list.
144	Cannot use an aggregate or a subquery in an expression used for the group by list of a GROUP BY clause.
145	ORDER BY items must appear in the select list if SELECT DISTINCT is specified.
146	Could not allocate ancillary table for a subquery. Maximum number of tables in a query (%d) exceeded.
147	An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being aggregated is an outer reference.
148	Incorrect time syntax in time string '%.*ls' used with WAITFOR.
149	Time value '%.*ls' used with WAITFOR is not a valid value. Check date/time syntax.
150	Both terms of an outer join must contain columns.
151	'%.*ls' is an invalid money value.
153	Invalid usage of the option %.*ls in the %ls statement.
154	%S_MSG is not allowed in %S_MSG.
155	'%.*ls' is not a recognized %ls option.
156	Incorrect syntax near the keyword '%.*ls'.
157	An aggregate may not appear in the set list of an UPDATE statement.
159	For DROP INDEX, you must give both the table and the index name, in the form tablename.indexname.
160	Rule does not contain a variable.
161	Rule contains more than one variable.
163	The compute by list does not match the order by list.
164	GROUP BY expressions must refer to column names that appear in the select list.
165	Privilege %ls may not be granted or revoked.
166	'%ls' does not allow specifying the database name as a prefix to the object name.
167	Cannot create a trigger on a temporary object.
168	The %S_MSG '%.*ls' is out of the range of computer representation (%d bytes).
169	A column has been specified more than once in the order by list. Columns in the order by list must be unique.
170	Line %d: Incorrect syntax near '%.*ls'.
171	Cannot use SELECT INTO in browse mode.
172	Cannot use HOLDLOCK in browse mode.
173	The definition for column '%.*ls' must include a data type.
174	The %ls function requires %d arguments.
177	The IDENTITY function can only be used when the SELECT statement has an INTO clause.
178	A RETURN statement with a return value cannot be used in this context.
179	Cannot use the OUTPUT option when passing a constant to a stored procedure.
180	There are too many parameters in this %ls statement. The maximum number is %d.
181	Cannot use the OUTPUT option in a DECLARE statement.
182	Table and column names must be supplied for the READTEXT or WRITETEXT utility.
183	The scale (%d) for column '%.*ls' must be within the range %d to %d.
185	Data stream is invalid for WRITETEXT statement in bulk form.
186	Data stream missing from WRITETEXT statement.
188	Cannot specify a log device in a CREATE DATABASE statement without also specifying at least one non-log device.
189	The %ls function requires %d to %d arguments.
191	Some part of your SQL statement is nested too deeply. Rewrite the query or break it up into smaller queries.
192	The scale must be less than or equal to the precision.
193	The object or column name starting with '%.*ls' is too long. The maximum length is %d characters.
194	A SELECT INTO statement cannot contain a SELECT statement that assigns values to a variable.
195	'%.*ls' is not a recognized %S_MSG.
196	SELECT INTO must be the first query in an SQL statement containing a UNION operator.
197	EXECUTE cannot be used as a source when inserting into a table variable.
198	Browse mode is invalid for statements containing a UNION operator.
199	An INSERT statement cannot contain a SELECT statement that assigns values to a variable.