How many types of cursors are there in SQL Server?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

528


What is the difference between SQL notification and SQL invalidation?

593


Is INSTEAD OF trigger directly applicable to Table ?

576


What is the difference between function and stored procedure in sql server?

491


Is there any difference between primary key and unique with the not null condition?

532






How to use order by with union operators in ms sql server?

577


Do you know sql server 2008 backup compression?

572


what information is maintained within the msdb database? : Sql server administration

512


What is local temp table?

558


What are data driven subscriptions?

79


What structure can you implement for the database to speed up table reads?

716


What is the difference between the application object and session object?

602


How do I find the transaction log size in sql server?

520


What is the largest component inside a field?

535


Does partitioning improve performance?

495