What are cursors? Name four types of cursors and when each
one would be applied?
- 3 Answers
- 19189 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
Describe and explain about SQL native client?
Does sql server 2000 clustering support load balancing?
What are the differences between DDL, DML and DCL in SQL?
Define full outer join?
How to enter unicode character string literals in ms sql server?
How do I perform an unattended install of sql server 2000?
What is a fan-out query in SQL Azure?
What is difference between group by and having?
What is not null constraint?
What do you mean by acid?
How can we delete a table in sql server?
What are the advantages of using third-party tools?
What is the boxing and unboxing concept in .net?
Can group by be used without aggregate functions?
What is the current limitation of the size of SQL Azure DB?
