Do you know the cursor optimization tips?
Submitted by: AdministratorClose 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.
Submitted by: Administrator
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.
Submitted by: Administrator
Read Online SQL Server Cursors Job Interview Questions And Answers
Top SQL Server Cursors Questions
☺ | What is cursor in MS SQL Server? |
☺ | Explain the cursor lock types? |
☺ | What is scrollable cursor? |
☺ | Do you know the capabilities of Cursors? |
☺ | Explain Temporary table VS Table variable by using Cursor alternative? |
Top New MS SQL Server Categories
☺ | SQL Server Database Administrator Interview Questions. |
☺ | SQL Server Service Broker Interview Questions. |
☺ | SQL Server Locks Interview Questions. |
☺ | SQL Server Constraints Interview Questions. |
☺ | MS SQL Data Mining Interview Questions. |