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

Answer Posted / rajiv rohilla

In SQL Server 2000 Cursors are used in stored procedures /
Functions where we have to go each record of a recordset
one by one.

Is This Answer Correct ?    16 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Indexes are updated automatically is the full-text index also updated automatically?

627


What is a periodical index?

510


List types of tables in SQL Azure?

102


How will you monitor replication latency in transactional replication? : sql server replication

616


How do I setup a sql server database?

550






What is sql injection? How to protect against sql injection attack?

557


What are dml triggers and types of dml triggers?

553


Explain what is cte (common table expression)?

626


Can the query output be sorted by multiple columns in ms sql server?

555


What is transaction server distributed transaction?

561


Explain iaas, paas and saas?

74


A trigger can reference objects outside the current database? State true or false.

555


Do you know sql server 2008 backup compression?

568


What is a constant or literal in ms sql server?

599


Explain the collation?

627