Posted by Doug on 02/26/06 03:57

interesting take on cursors.
I have never used cursors in client code. seemed pretty inefficient to
pass all that crud across the net, and leave the cursor open until the
clients cpu can process it.

i've used cursors extensively in stored procedures.

The cursor is the last resort. Whenever possible use set based
solutions. But if you have to process each record step by step,
sometimes it is the only way.

[Back to original message]