What are cursors? Name four types of cursors and when each
one would be applied?
- 3 Answers
- 18885 Views
- Adea Solutions, I also Faced
- E-Mail Answers
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
Explain magic tables in sql server?
What is normalization? Explain different forms of normalization?
What is a raid and what are different types of raid configurations?
What are the five major components of a dbms?
What is dirty page?
What is the function of sql server agent windows service?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What are subquery and its properties?
What is a synonym for manipulation?
Do you know sql server 2008 introduces automatic auditing?
What is the new security features added in sql server 2014? : sql server security
Can you name a few encryption mechanisms in sql server?
Does a full backup include transaction log?
What is the difference between DataRow.Delete() and DataRow.Remove()?
Explain primary key and foreign key constraints?
