Search code examples
sqlsql-serverloopst-sqlsyntax

Syntax of for-loop in SQL Server


What is the syntax of a for loop in TSQL?


Solution

  • T-SQL doesn't have a FOR loop, it has a WHILE loop
    WHILE (Transact-SQL)

    WHILE Boolean_expression
    BEGIN
    
    END