Hi Guys,

[nithyapriya]

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

[almaz]

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.

[nithyapriya]

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.