Type of cursors

1)Static cursors
2)Dynamic cursors
3)Forward-only cursors
4)Keyset-driven cursors

Static cursors detect few or no changes but consume relatively few resources while scrolling, although they store the entire cursor in tempdb.
Dynamic cursors detect all changes but consume more resources while scrolling, although they make the lightest use of tempdb.
Keyset-driven cursors lie in between, detecting most changes but at less expense than dynamic cursors.