while « Transact SQL « SQL Server / T-SQL Tutorial

20.8.1.How to perform repetitive processing
20.8.3.This procedure inserts rows by using while loop
20.8.4.Insert 100 rows of data: RAND
20.8.5.While with counter
20.8.6.Use while loop to insert data
20.8.7.While loop controlled by an aggregate function
20.8.8.WHILE with AND operator
20.8.9.A script that tests and adjusts credit amounts with a WHILE loop

20.8.10.Using a Subquery with a Single-Statement WHILE Loop