Interested to Buy Any Domain ? << Click Here >> for more details...
How many types of cursors are there in SQL Server?
- 5 Answers
- 22219 Views
- 247Customer, CarrizalSoft Technologies, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / nalini
Cursor is the current position of recordset.There are 4
types of cursors.
1.forward Only (Default)
2.Static
3.Keyset
4.Dynamic
| Is This Answer Correct ? | 32 Yes | 4 No |
Answer / santosh kumar sharma
There are 4 types of cursor.
1) Static: Cursor can move to any record but the changes on
the data can't be seen.
2) Dynamic: Most resource extensive. Cursor can move
anywhere and all the changes on the data can be viewed.
3) forward-only: Cursor moves one step forward. Can't move
backwards.
4) Key setdriven: Only Updated data can be viewed. Deleted
and Inserted data cannot be viewed.
| Is This Answer Correct ? | 18 Yes | 3 No |
There are five type of cursors in SQL server.
1)Base table:- This is lowest level cursor.
2)Static :- This is scrollable query cursor in earlier
versions of SQL Server Compact Edition
3)Forward-only:- The forward-only cursor is the fastest
cursor that you can update, but it does not support
scrolling.
4)Forward-only/Read-only:- Forward-only/read-only cursors,
referred to as forward-only cursors in earlier versions of
SQL Server Compact Edition, are the fastest cursors, but
cannot be updated.
5)Keyset-driven:- The keyset-driven cursor in SQL Server
Compact Edition is a scrollable cursor that you can update.
A keyset-driven cursor is controlled by a set of physical
identifiers known as the keyset.
| Is This Answer Correct ? | 13 Yes | 3 No |
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 |
What is cube dimension? : sql server analysis services, ssas
What are the options which must be set to allow the usage of optimistic models?
Which are the third-party tools used in sql server and why would you use them?
What is Cross Join and in which scenario do we use Cross Join?
what type of indexes physically sort data?
Which is faster statement or preparedstatement?
What is difference statement and preparedstatement?
what is the diffrence between Snap Shot and Transaction Replication
Do you know what are different types of replication in sql server?
What stored by the msdb? : sql server database administration
Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC
Can you create UNIQUE and PRIMARY KEY constraints on computed columns in SQL Server 2000?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
