SQL Server Cursors Question:
Download Job Interview Questions and Answers PDF
Do you know the cursor types?
Answer:
DYNAMIC: It reflects changes happened on the table while scrolling through the row.
STATIC: It works on snapshot of record set and disconnects from the server. This kind doesn’t reflects changes happened on the table while scrolling through the row.
KEYSET: In this kind, new record is not reflected, but data modification can be seen
STATIC: It works on snapshot of record set and disconnects from the server. This kind doesn’t reflects changes happened on the table while scrolling through the row.
KEYSET: In this kind, new record is not reflected, but data modification can be seen
Download MS SQL Server Cursors Interview Questions And Answers
PDF
Previous Question | Next Question |
Do you know the cursor optimization tips? | What is Implicit cursors? |