Interested to Buy Any Domain ? << Click Here >> for more details...
What are cursors? Name four types of cursors and when each
one would be applied?
- 3 Answers
- 20299 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
Do you have any idea about the tcl commands?
What is an index in a database?
Can we install sql server 2016 on windows 7?
What is the advantage of sql server?
When to use Inner join & when to use subquery?
What is collation sensitivity?
Do you know exporting and importing utility?
What is optimistic concurrency?
What is the use of builtinadministrators group in sql server? : sql server security
Relational calculus is what type of language?
How to transfer a table from one schema to another?
Can you explain powershell included in sql server 2008?
How to provide column names in insert statements in ms sql server?
What is executereader?
What is the purpose of floor function?
