Following are the different types of cursors in Sql Server:
- Base Table : These are the lowest level cursor available. These can scroll forward or backward with minimal cost, and can be updated.
- Static : Cursor can move to any record, but the changes on data can't be seen.
- Forward-Only : Cursor moves one step forward. Can't move backward
- Dynamic : Most resource extensive. Cursor can move anywhere and all the changes on the data can be seen
- Keyset-driven : Only updated data can be viewed, inserted and deleted data cannot be viewed.
No comments:
Post a Comment