SQL Server Cursors Question:
Explain the ways to controlling Cursor Behavior?
Answer:
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.
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.
| Previous Question | Next Question |
| Do you know the capabilities of Cursors? | Explain the steps to use Transact-SQL Cursor? |