Showing posts with label cursors. Show all posts
Showing posts with label cursors. Show all posts

Wednesday, March 21, 2012

Hi Guys,

I'm nithya. Can we have nested cursors in SQL2000?

Quote:

Originally Posted by nithyapriya

I'm nithya. Can we have nested cursors in SQL2000?


You can, but if you want your server code to be efficient - try not to use triggers at all. There is a very small set of tasks on SQL Server that cannot be accomplished with standard set-based operations requiring cursors to be used.|||

Quote:

Originally Posted by almaz

You can, but if you want your server code to be efficient - try not to use triggers at all. There is a very small set of tasks on SQL Server that cannot be accomplished with standard set-based operations requiring cursors to be used.


Thank you for your reply. Nithya.