Avoid Cursors

Posted by:sukanyakaur 1258 days ago • 1 Comment • http://toostep.com

Avoid Cursors   There may be times when you need to loop through a resultset a row at a time and perform a certain action for each row. The most obvious way to solve this task is to use a SQL Cursor . Whilst cursors may seem like a good idea they can often cause your database application problems as they can lock the tables that are used to populate the cursor whilst the rows in the cursor are...

enhance       avoid cursor       cursor       tips       sql       performance