How Would You Know That If A Cursor Is Open Or Closed?

1.	How Would You Know That If A Cursor Is Open Or Closed?
Answer» Answer : declare @mycursor cursor declare @FirstName VARCHAR(12) SELECT CURSOR_STATUS('variable','@mycursor') --// -2 (Not applicable) SET @mycursor = cursor for select FirstName from Person.Contact select CURSOR_STATUS('variable','@mycursor') --// -1 (The cursor is closed) open @mycursor select CURSOR_STATUS('variable','@mycursor') --// 1 (The result set of the cursor has at least one row) fetch next from @mycursor into @FirstName select CURSOR_STATUS('variable','@mycursor') --// 1 (The result set of the cursor has at least one row) close @mycursor select CURSOR_STATUS('variable','@mycursor') --// -1 (The cursor is closed) deallocate @mycursor select CURSOR_STATUS('variable','@mycursor') --// -2 (Not applicable) select CURSOR_STATUS('variable','@nocursor') --// -3 (A cursor with the specified NAME does not exist)

Discussion