How many types of cursors are there in SQL Server?




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 ?    31 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



More SQL Server Interview Questions

What is the importance of concurrency control?

0 Answers  


what is the output for this query select * from employee where 1=1;

4 Answers  


1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  


Tell me about normalization in DBMS.

0 Answers   Honeywell, Zomato,


List the different normalization forms?

0 Answers  






Can we perform backup restore operation on tempdb?

0 Answers  


What is the simplest way to create a new database in ms sql server?

0 Answers  


Tell me about builtinadministrator?

0 Answers  


How to use union to merge outputs from two queries together in ms sql server?

0 Answers  


hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000

3 Answers  


Find top Nth employee from each department in terms of salary?

13 Answers   RealPage,


How to perform key word search in tables?

0 Answers  






Categories