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 is difference between view and materialized view?

540


How do I view a stored procedure in sql server?

522


how you can configure a running aggregate in SSRS?

114


What is function of ROLLUP ?

658


How to retrieve field values using mssql_result()?

632






query processing

1737


Can you import Microsoft Excel data to SSRS?

89


What is the use of =,==,=== operators?

581


Help!!!!!!!!!!!! My database has gone offline, it is highlighted as 'Suspect'. Foolishly, i haven't got a recent back up. Is there a way of quickly restoring the database? Thank you

1305


List out the differences between global and local temp tables in sql server?

578


what’s the difference between Covering Indexes and Clustered Indexes ? how to use clustered index small ?

1579


What is a file group?

624


What is difference between line feed ( ) and carriage return ( )?

526


Explain error handling in ssis?

573


Give me a SQL Query to find out the second largest company?

694