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

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.

Answer / hari

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

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.

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.

What program is used to store the data source file?

0 Answers  

Explain what are various ways to enhance the ssrs report?

0 Answers  

How we can refresh the view?

0 Answers  

How to find Duplicate Records In table?

0 Answers   HCL,

Define master database?

0 Answers  

What are partitioned views and distributed partitioned views?

0 Answers  

What is user-defined multi-statement table-valued function?

0 Answers  

What are xml indexes?

0 Answers  

can any body tell me how to know the password of current user in sql server

0 Answers   Crea, HCL,

What is live lock and deadlock? what is Lock escalation?

2 Answers   Microsoft,

Explain sub-query?

0 Answers  

How many types of Outer Joins?What are they?

1 Answers