8 followers Follow

Avoid using SQL queries inside a loop

Question1: Can you please let me know some samples of remediated (corrected code) using set based approach along with violation code using loop. For select, update and insert scenarios each.

Question2: I am also attaching a picture of code with violation (means it is running queries inside a loop, now can you please also provide corrected solution of this code with set based approach)

Please sign in to leave a comment.