How many types of cursors are there in SQL Server?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / srikanth

5 Answers
20429 Views
247Customer, CarrizalSoft Technologies, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

How many types of cursors are there in SQL Server?..

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

How many types of cursors are there in SQL Server?..

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

How many types of cursors are there in SQL Server?..

Answer / hari

Cursor : Curosr is allow row processing of the result set.
Static
Dynamic
forward-only
Key setdriven

Is This Answer Correct ?

16 Yes

3 No

How many types of cursors are there in SQL Server?..

Answer / vikash kumar mishra

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

How many types of cursors are there in SQL Server?..

Answer / 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