What are cursors? Name four types of cursors and when each
one would be applied?
Answer Posted / basha
Following are different types of cursors available in SQL Server 2005 :
Base table
Static
Dynamic
Forward-only/Read-only
Keyset-driven
Base table: Base table cursors are the lowest level of cursor available. Base table cursors can scroll forward or backward with minimal cost, and can be updated
Static: Cursor can move to any record but the changes on the data can’t be seen.
Dynamic: Most resource extensive. Cursor can move anywhere and all the changes on the data can be viewed.
Forward-only: Cursor moves one step forward, can’t move backwards.
Keyset-driven: Only updated data can be viewed, deleted and inserted data cannot be viewed.
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the advantages of passing name-value pairs as parameters?
What is a domain constraint give an example?
How will you go about resolving deadlocks?
What is precedence constraint?
What is Transparent Data Encryption?
Explain different types of lock modes in sql server 2000?
What are xml indexes?
Explain datetime2 data type in sal server 2008?
What is the difference between functions and scalar functions?
How to defragment table indexes?
What is the difference function and stored procedure?
What are clustered and non-clustered index?
Explain what are various ways to enhance the ssrs report?
Why the trigger fires multiple times in single login?
Explain the phases a transaction has to undergo?