SQL Server Cursors Question: Download MS SQL Server Cursors PDF
What is scrollable cursor?
Answer:
You can use keyword SCROLL to make cursor Scrollable.
It can scroll to any row and can access the same row in the result set multiple times.
A non-scrollable cursor is also known as forward-only and each row can be fetched at most once.
It can scroll to any row and can access the same row in the result set multiple times.
A non-scrollable cursor is also known as forward-only and each row can be fetched at most once.
| Previous Question | Next Question |
| Explain Temporary table VS Table variable by using Cursor alternative? | Do you know the capabilities of Cursors? |