Do you know the cursor types?
Submitted by: AdministratorDYNAMIC: 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
Submitted by: Administrator
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
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. |
