2024年6月11日发(作者：)

sql server 2000 错误信息解释（SQL Server 2000错误信息解释）

Description of error severity (message text)

110 last upgrade version date: 10/11/90.

2110 warning: serious error%1! Occurred in%2!. Please note the

error and time, and then contact the system administrator.

10215 syntax errors near''%1!!'.

10315%1 with''%2 Too long. The maximum length is%4!.

10415 if the statement contains the UNION operator, then the

items in the ORDER BY clause must appear in the selection list.

10515 string''%1!! 'before there is an unclosed quotation mark.

10616 there are too many table names in the query. The maximum

allowable number is%1!.

The 10715 column prefix''%1 '' does not match the table name

or alias used in the query.

The position of%1 10815 ORDER in the BY clause exceeds the

number of items in the select list.

The number of columns in the 10915 INSERT statement is greater

than the number specified in the VALUES clause. The number of

VALUES clauses must be matched to the number of columns

specified in the INSERT statement.

The number of columns in the 11015 INSERT statement is less than

the number specified in the VALUES clause. The number of VALUES

clauses must be matched to the number of columns specified in

the INSERT statement.

11115''%1! 'must be the first statement in the batch query.

11215%1! No variables are allowed in the statement.

11315 short notes at the end of'*/'mark.

11415 invalid access mode for statements that assign values to

variables.

11615 when you do not introduce a subquery with EXISTS, you can

only specify an expression in the selection list.

11715%1! Name''%2! 'contains the number of prefixes greater

than the maximum value. The maximum value is%4!.

11815 only the members of the sysadmin role can specify the%1!%2

option of the statement.

11915, you must pass the number of parameters%1, and pass the

following parameters in the form of'@name = value'. Once

the'@name = value'form is used, all subsequent parameters must

be passed in the form of'@name = value'.

The selection list of the 12015 INSERT statement contains less

entries than that in the insert list. The number of SELECT

statements must match the number of columns in the INSERT