In SQL Server 2000 Cursors are used in stored procedures / Functions wher

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

Question Posted / rajiv rohilla

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

Please Help Members By Posting Answers For Below Questions

What is local temp table?

1020

How do I save a stored procedure in sql server?

1041

role of sql sever 2005 in database rather than any other database

1984

If user is owning any SQL Objects, can we drop that user

2127

what is a join and explain different types of joins? : Sql server database administration

1000

How to create a large table with random data for index testing in ms sql server?

1064

How to add code to the existing article (using improve article)?

1162

How to provide default values to function parameters?

1216

explain extended properties

1036

How to create a simple table to test triggers in ms sql server?

1032

Explain about temporary stored procedure?

1091

How to trouble shoot if unable to connect SQL Server

2026

Which tcp/ip port does the sql server run on? How can it be changed?

1098

Explain “row_number()” in sql server with an example?

1053

What are the essential components of sql server service broker?

1065