What are the ways to controlling Cursor Behavior?Cursors behavior can be controlled by dividing them into cursor types: forward-only, static, keyset-driven, and dynamic. SQL server supports keywords SCROLL and INSENSITIVE to define cursor behavior in terms of scrollability and sensitivity.
What are the ways to controlling Cursor Behavior?There are 2 ways to control Cursor behavior:
- Cursor Types: Data access behavior depends on the type of cursor; forward only, static, keyset-drive and dynamic.
- Cursor behaviors: Keywords such as SCROLL and INSENSITIVE along with the Cursor declaration define scrollability and sensitivity of the cursor.