how to use while in loop in sql server

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