3 ms·
As said above, SQL is a set based language and one shouldn’t write a cursor to deal with individual rows unless no other way. And if writing a server side curs
by fsuts 3mo ago
As said above, SQL is a set based language and one shouldn’t write a cursor to deal with individual rows unless no other way.
And if writing a server side cursor, probably better to write a stored procedure /function and put the cursor and its logic in it, and then call that rather than handle in application