Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of cursors are there in SQL Server?
- 5 Answers
- 22211 Views
- 247Customer, CarrizalSoft Technologies, I also Faced
- E-Mail Answers
Answer Posted / sandip borkar
There can be 7 types of Cursors in SQL Server
1] Dynamic : Scrollable. Its slowest, and sensitive to all changes in resultset.
2] Keyset : Scrollable. Its slow but faster than Dynamic.Sensitive to Changes like updation and deletion but not insertion
3] Static : Its srollable and faster than both above. We can move forward and backward, but changes are not visible
4] Forward_Only Dynamic : Its not scrollable, but sensitive to changes.
5] Forward_only keyset : Its not scrollable, but sensitive to updation and deletion in resultset but not insertion. We can only move forward and not backward.
6] Forward_only Static : Not sensitive to changes not scrollable.
7] Fast-forward : fastest among all.
| Is This Answer Correct ? | 1 Yes | 6 No |
Post New Answer View All Answers
What is equi join with example?
Can sql servers linked to other servers?
how to use DTS package in 2000,2005,2008 in sql server
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Why I am getting this error when renaming a database in ms sql server?
What is in place upgrade in sql server?
What is table-valued sub query?
What is the use of floor function in sql server?
How many databases can we create in a single server?
what is a mixed extent? : Sql server administration
Explain subquery and state its properties?
Explain raiserror in sql server?
Can you explain different types of locks in sql server?
How can I create a report based on a query? : sql server management studio
Which is better statement or preparedstatement?
