| SQLSTATE代码和消息 |
|
警告 | 需要用户用户注意但尚未严重妨碍SQL语句成功执行的情况 | |
例外 | 使用SQL语句无法对数据库产生影响的情况 | |
| SQLSTATE代码存储在sysmessages系统表中 | |
|
|
|
消息 | 中文解释 | 发生条件 |
警告 |
|
|
Warning-null value eliminated in set funcation | 警告-set函数中的NULL值已经消除 | 对具有NULL值的表达式使用集合函数(avg/max/min/sum/count)时会出现此信息 |
Warning-string data,right truncation | 警告-字符串数据,右截断 | 将字符,unichar或二进制数据截断为255字节时会出现此信息. |
|
|
|
基数冲突 |
|
|
Subquery returned more than 1value.this is illegal when the subquery follow =,!=,<,<=,>=,or when the subquery is user as an expression | 子查询返还不止一个值,当子查询跟在=,!=,<之后或者当子查询用作表达式时,这种情况是非法的 | 标量子查询或行子查询返回不止一行 |
|
|
|
数据例外 |
|
|
Arithmetic overflow occurred | 发生算术溢出 | 算术运算或SUM函数,以及截断,舍入使精确数值类型丢失精度或标度 |
Data exception-string data right truncated | 数据例外-字符串从右侧被截断 | 列太短,不能容纳插入或更新的数据,而必须截断非空字符. |
Divide by zero occurred | 发生零除错误 | 对数字表达式求值而除数的值为零 |
Illegal escape character found.There are fewer bytes than necessary to form a valid character | 发现非法的转义字符,形成有效字符所需的字节数不过. | 在转义序列不是由单个字符构成时,搜索与给定模式相匹配的字符串. |
Invalid pattern string.The character following the escape character must be percent sign ,underscore ,left square bracket, right square bracket, or the escape character. | 无效的模式字符串.转义字符后的字符必须是百分号,下划线,左方括号,右方括号或转义字符 | 搜索与特定模式相匹配的字符串时. |
|
|
|
完整性约束冲突 | Insert,update或delete语句与primary key ,foreign key .check或unique约束或唯一索引发生冲突. | |
Attempt to insert duplicate key row in object_name with unique index index_name | 试图在具有唯一索引index_name的对象object_name中插入重复的键行 | 在具有唯一约束或索引的表中插入重复的行. |
Check constraint violation occurred ,daname=database_name,table name=table_name,constraint name=constraint_name. | 发生检查约束冲突 | Update或delete与列的检查约束发生冲突. |
Dependent foreign key constraint violation in a referential integrity constraint | 参照完整性约束中发生相关外键约束冲突. | 主键表上的update或delete与外键约束发生冲突. |
Foreign key constraint violation occurred, | 发生外键约束冲突 | 在主键表中无匹配值的情况下对外键表执行insert或update |
|
|
|
无效的游标状态 |
|
|
Attempt to use cursor cursor_name which is not open.Use the system stored procedure sp_cursorinfo for more information. | 试图使用未打开的游标cursor_name.有关详细信息,请使用系统存储过程sp_cursorinfo | 试图从未打开或已被commit语句或者隐式(或显式)rollback关闭的游标中进行读取.重新打开游标并重新执行fetch |
Cursor cursor_name was closed implicitly because the current cursor position was deleted due to an update or a delete.The cursor scan position could not be recovered.This happens for cursors which reference more than one table. | 由于当前游标位置因执行update 或delete而被删除,因此游标cursor_name被隐式关闭. | 多表游标的连接已被删除或更改.发出另一个fetch以重新定位游标. |
|
|
|
<span style="font-size: 11pt; font-family: 宋体; mso-ascii-font-family: 'Times New Roman'; mso-hansi-font-family: |
o......
好像页面出现 bug 了!!