Syntax of for-loop in SQL Server
What is the syntax of a for loop in TSQL?
There is no for-loop, only the while-loop:
DECLARE @i int = 0
WHILE @i < 20
BEGIN
SET @i = @i + 1
/* do some work */
END
T-SQL doesn't have a FOR loop, it has a WHILE loop
WHILE (Transact-SQL)
WHILE Boolean_expression
BEGIN
END