DECLARE @Temp TABLE
(
ii int
)
INSERT INTO @Temp(ii) VALUES(1)
INSERT INTO @Temp(ii) VALUES(2)
INSERT INTO @Temp(ii) VALUES(3)
--Create a cursor.
DECLARE cur CURSOR
FOR SELECT * FROM @Temp
--Display the status of the cursor before and after opening
--closing the cursor.
SELECT CURSOR_STATUS('global','cur') AS 'After declare'
OPEN cur
SELECT CURSOR_STATUS('global','cur') AS 'After Open'
CLOSE cur
SELECT CURSOR_STATUS('global','cur') AS 'After Close'
--Remove the cursor.
DEALLOCATE cur
SELECT CURSOR_STATUS('global','cur') AS 'After Deallocate'
Output:
After declare
-1
After Open
1
After Close
-1
After Close
-3