Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Useage of Cursors in SQL 2000

Author  Topic 

hnomani
Starting Member

35 Posts

Posted - 2001-05-10 : 10:21:23
I am coming from Oracle background and have recently stated working with SQL server 2000. Someone suggested me not to use “Cursors” in stored procedure. I have a requirement where I have to loop through a set of records and pass its values to a set of update statements, typically done by explicit cursors in Oracle. Is there a way I can do this without using Cursors in SQL Server 2000 and how is this going to effect my performance?
   

- Advertisement -