怎样获得打开的游标信息

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