Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of cursors are there in SQL Server?
- 5 Answers
- 22488 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 Federation Root Database?
Explain having clause and where clause?
difference between Clustered index and non clustered index ?
what are the types of indexes? : Sql server database administration
What is the sql case statement used for? Explain with an example?
what are the reporting service components in SSRS?
What is the use of group by clause?
How to modify the underlying query of an existing view?
How to drop an existing stored procedure in ms sql server?
How do we know if any query is retrieving a large amount of data or very little data?
Do you know what is replace and stuff function in sql server?
What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?
To which devices can a backup be created and where should these devices be located? : sql server management studio
What is a field name?
Define cross join in sql server joins?
