Sybase ＩＱ中的 ＠＠ｅｒｒｏｒ ＠ｓｑｌｓｔａｔｕｓ

[春雨-rain]

请教一下高手：

　　　Ｓｙｂａｓｅ　中有好多系统的变量，比如上面的那俩个，我想问下，每个变量具体的取值表示什么意思呢？

　　例如＠ｅｒｒｏｒ就有０－－表示没有错误
　　１
２
３
。。。。
这些数字又表示什么错误呢？
非常感谢！！

[Sybase数据库恢复]

看官方文档啊。

[s46871]

@@sqlstatus values Value
Meaning

0
The fetch statement completed successfully.

1
The fetch statement resulted in an error.

2
There is no more data in the result set. This warning occurs if the current cursor position is on the last row in the result set and the client submits a fetch command for that cursor.

[s46871]

The @@error global variable is commonly used to check the error status of the most recently executed batch in the current user session. @@error contains 0 if the last transaction succeeded; otherwise @@error contains the last error number generated by the system. A statement such as if @@error != 0 followed by return causes an exit on error.

Every Transact-SQL statement, including print statements and if tests, resets @@error, so the status check must immediately follow the batch whose success is in question.