Static Cursor

Scroll cursor specifies that cursor can fetch data in all directions, not only sequentially until the end of the result set. If this argument is not specified, FETCH NEXT is the only fetch option supported.

Static cursor - The complete result set of a static cursor is built in tempdb when the cursor is opened. A static cursor always displays the result set as it was when the cursor was opened. If any data is inserted after the cursor is opened, the cursor will not be fetching the new records. SQL Server static cursors are always read-only. Because the result set of a static cursor is stored in a work table in tempdb, the size of the rows in the result set cannot exceed the maximum row size for a SQL Server table.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Satyapriya Nayak14y ago
Hi Swati,

Please refer the below links

http://msdn.microsoft.com/en-us/library/ms191286%28v=sql.105%29.aspx

http://www.dotnet-tricks.com/Tutorial/sqlserver/RLID060512-SQL-Server-Different-Types-of-Cursors.html

Thanks
If this post helps you mark it as answer
Akkiraju Ivaturi14y ago
Scroll cursor specifies that cursor can fetch data in all directions, not only sequentially until the end of the result set. If this argument is not specified, FETCH NEXT is the only fetch option supported.

Static cursor - The complete result set of a static cursor is built in tempdb when the cursor is opened. A static cursor always displays the result set as it was when the cursor was opened. If any data is inserted after the cursor is opened, the cursor will not be fetching the new records. SQL Server static cursors are always read-only. Because the result set of a static cursor is stored in a work table in tempdb, the size of the rows in the result set cannot exceed the maximum row size for a SQL Server table.