Why it is said to avoid WHILE Loops in SQL Server?

 Posted by Rajnilari2015 on 2/4/2016 | Category: Sql Server Interview questions | Views: 365 | Points: 40
Answer:

In the case of While loops the rows are rows are processed one after another and hence if we want to submit any job(s) to the query engine, it process in a sequential manner.Where as if we can re-write the same query by using in a SET Based manner, we can submit a complete batch of job(s) to the query engine which on the other hand will be processed much faster way.


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response