What is a cursor in SQL Server 2000 and their types?

Answer Posted / sd

Cursors allow row-by-row prcessing of the resultsets.

Types of cursors: Static, Dynamic, Forward-only, Keyset-
driven

Is This Answer Correct ?    30 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are types of scd? : sql server analysis services, ssas

538


How to verify a login name with sqlcmd tool?

591


How to turn off warning messages during php execution?

526


what are user defined datatypes? : Sql server database administration

514


What is provisioning, billing and metering, and connection routing concepts in the service layer?

92






how do you test proper tcp/ip configuration windows machine? : Sql server database administration

519


what types of replication are supported in sql server? : Sql server database administration

459


What is set nocount on?

498


Are resultset updatable?

522


What are truncate options available in sql server? : sql server database administration

579


How to get the definition of a trigger back?

544


Can group by be used without aggregate functions?

477


What are the types of dml?

554


Does index speed up select statements?

581


What is the query and subquery?

618