Cursors allow row-by-row prcessing of the resultsets. Types of cursors:

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

Question Posted / arshad abbasi

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

Please Help Members By Posting Answers For Below Questions

How to drop an existing schema in ms sql server?

1142

What is wrong with sql server client libarary dll, ntwdblib.dll?

1088

How to modify existing triggers using "alter trigger"?

1063

Equi join and non equi join is possible with sql server?

1089

What are the hotfixes and patches in sql server?

1062

How do you handle datasets larger than 50 gb?

164

what is the difference between writing data to mirrored drives versus raid5 drives. : Sql server administration

1008

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1056

Define right outer join in sql server joins?

1109

What is tempdb database? : SQL Server Architecture

1254

Name some of the open source software that you can use in alternative to SSR?

170

what is the system function to get the current user's user id? : Sql server database administration

1068

What is the difference between coalesce() & isnull()?

1187

How can we rewrite sub-queries into simple select statements or with joins?

1027

What is data modeling and Reterminal integrity?

2008