sql server while loop

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