34,838
社区成员




select * from sys.dm_exec_cursors(0) as A cross apply sys.dm_exec_sql_text(A.sql_handle)
--SELECT @@CURSOR_ROWS;
USE AdventureWorks;
GO
SELECT @@CURSOR_ROWS;
DECLARE Name_Cursor CURSOR FOR
SELECT LastName ,@@CURSOR_ROWS FROM Person.Contact;
OPEN Name_Cursor;
FETCH NEXT FROM Name_Cursor;
SELECT @@CURSOR_ROWS;
CLOSE Name_Cursor;
DEALLOCATE Name_Cursor;
GO