Transact SQL MSSQL Tutorial

The syntax of the WHILE statement
WHILE expression
    {statement|BEGIN...END}
    [BREAK]
    [CONTINUE]