Types of Cursors in SQL SERVER
The types of Cursors are as mentioned below Static The static cursors are those where the data on retrieval is not modified and remains as before it entered the cursor since its stored in the tempdb. This is also know as read-only cursors. Forward The forward only cursors can move forward in the result set. Dynamic The dynamic cursors identify all changes to data inside of the cursor or from outside by other users. If a particular data in a row was changed after that dataset was assigned to cursor, when that rows comes up we do see the modified data. Keyset-Driven The keyset cursors is such that when the cursor is open it will see the modifications happened for any row outside by other user before assigned to the cursor but will not see new records added.