SQL Server Cursors Question:
Download Job Interview Questions and Answers PDF
Explain the cursor lock types?
Answer:
Three types of locks
READ ONLY: This prevents any updates on the table.
SCROLL LOCK: This allows you to make changes to the table.
OPTIMISTIC: This checks if any change in the table record since the row fetched before updating.
If there is no change, the cursor can update
READ ONLY: This prevents any updates on the table.
SCROLL LOCK: This allows you to make changes to the table.
OPTIMISTIC: This checks if any change in the table record since the row fetched before updating.
If there is no change, the cursor can update
Download MS SQL Server Cursors Interview Questions And Answers
PDF
| Previous Question | Next Question |
| How to avoid cursors? | Explain Temporary table VS Table variable by using Cursor alternative? |