@@FETCH_STATUS (TransactSQL)

@@FETCH_STATUS (Transact-SQL)

返回针对连接当前打开的任何游标发出的上一条游标 FETCH 语句的状态。

详细请参阅：http://msdn.microsoft.com/zh-cn/library/ms187308.aspx

以下示例使用 @@FETCH_STATUS 来控制 WHILE 循环中的游标活动。

DECLARE Employee_Cursor CURSOR FOR
SELECT BusinessEntityID, JobTitle
FROM AdventureWorks2008R2.HumanResources.Employee;
OPEN Employee_Cursor;
FETCH NEXT FROM Employee_Cursor;
WHILE @@FETCH_STATUS = 0
   BEGIN
      FETCH NEXT FROM Employee_Cursor;
   END;
CLOSE Employee_Cursor;
DEALLOCATE Employee_Cursor;
GO