I am also looking for the similar remediation for this.
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.
It will be helpful if some sample could be provided for remediation using set based approach.
I am also looking for the remediation sample of it.
Looking for the same. Kindly explain in a better way i.e providing some samples.