|
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.......
|
