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

Answer Posted / arshad abbasi

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

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

Is This Answer Correct ?    1 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are trace files?

533


Define constraints and give an example of their use?

559


What is the use of toad or sqldbx.?

716


When would you prefer to have a minimum number of indexes?

503


What is a heap?

615






What are the different subsets of sql?

949


How do you run a trace?

515


What is the use of nvl work?

561


How to override dml statements with triggers?

578


What is mapping schema?

576


Describe how to use linked server?

539


What are the filtered indexes?

598


What is rolap and its advantage? : sql server analysis services, ssas

640


What are cascading parameters in ssrs reports?

176


What is policy management?

575