while vs if else in sql

SQL Server WHILE loop sets a condition for the repeated execution of an SQL statement or statement block.