Skip to content Skip to sidebar Skip to footer

Using Cursor In Oltp Databases (sql Server)

Is it safe to use cursors in stored procs that are called from a website? There is the obvious performance hit, but what I am trying to raise here is the issue with the variable @@

Solution 1:

Unless you are using global cursors you should be safe

that said, why are you using cursors, almost everything can be accomplished set based in sql server and it will be many times faster in almost every situation

Post a Comment for "Using Cursor In Oltp Databases (sql Server)"