SQL Cursors

What is more effective than a cursors?  Given their (cursors) common use in stored procs?
TimSweet220Asked:
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.
 
0
 
deightonprogCommented:
for optimisation, it is better to use set based SQL if you can
0
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.