Syntax of for-loop in SQL Server

What is the syntax of a for loop in TSQL?

Answer

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

WHILE Boolean_expression
BEGIN

END