WHILE (Transact-SQL) - MSDN - Microsoft

Sets a condition for the repeated execution of an SQL statement or statement block. ... In the following example, if the average list price of a product is less than ...

msdn.microsoft.com