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.

No comments:

Post a Comment