SQL Server Cursor - Interview Questions on SQL Serve Cursor

A Cursor is a database object that represents a result set and is used to manipulate data row by row........
Declare the cursor, Open the cursor, Fetch record row by row, Close cursor, Deallocate cursor........
DYNAMIC: It reflects changes happened on the table while scrolling through the row........
Three types of locks READ ONLY: This prevents any updates on the table........
Close cursor when it is not required. You shouldn’t forget to deallocate cursor after closing it........
Cursor requires a network roundtrip each time it fetches a record, thus consume network resources........
You can use keyword SCROLL to make cursor Scrollable.......
Table variable that can be used in stored procedures, functions and batches.......