SQL Server Cursors Question:
Download Job Interview Questions and Answers PDF
Do you know the cursor optimization tips?
Answer:
Close cursor when it is not required.
You shouldn’t forget to deallocate cursor after closing it.
You should fetch least number of records.
You should use FORWARD ONLY option when there is no need to update rows.
You shouldn’t forget to deallocate cursor after closing it.
You should fetch least number of records.
You should use FORWARD ONLY option when there is no need to update rows.
Download MS SQL Server Cursors Interview Questions And Answers
PDF
| Previous Question | Next Question |
| What is cursor in MS SQL Server? | Do you know the cursor types? |