while vs if else vs goto in sql

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