SQL Server Loops

Question

Hi All In sql server which type of loop we are using mostly? and why Please give answer thanks everyone

Manav Pandya · Answer

Hello Yes  we can use for loop  while loop etc .. in Sql server Reason : Why : There is no specific reason to use loops with sql seerver  but main us of loop is to use some statement that needs iteration Same applies to sql server that if condition matches than it fall through some statements otherwise not But its not suggestive that to use loops in sql query  you can use other clause like where I hope you getting it Thanks