SQL Cursors

What is more effective than a cursors?  Given their (cursors) common use in stored procs?
Who is Participating?
Anthony PerkinsConnect With a Mentor Commented:
>>Given their (cursors) common use in stored procs?<<
It is rare that CURSORs are used in Stored Procedures and then usually in older code, where the developer migrated from MS Access and did not know any better.
for optimisation, it is better to use set based SQL if you can
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.