Syntax of for-loop in SQL Server

Question

What is the syntax of a for loop in TSQL?

Answer 1

T-SQL has WHILE loop, it doesn't have the FOR loop.

you can refer to WHILE (Transact-SQL)

Try this query:

WHILE Boolean_expression

BEGIN

END