Static Cursor

Question

What is static cursor in SQL Server and why we use it instead of using scroll cursor?

Satyapriya Nayak · Answer

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 Ivaturi · Answer

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 .