While loop sql

/* while loop SQL Server */
DECLARE @Counter INT 
SET @Counter = 1
WHILE (@Counter <= 10)
BEGIN
    PRINT 'The counter value is = ' + CONVERT(VARCHAR, @Counter)
    SET @Counter = @Counter  + 1
END

Source: sqlshack.com

Similar codes

2 votes189 views1 answer
Q operator in sql
SQL
0 vote292 views1 answer
How to get all values in a table mysql in c#
SQL
0 vote178 views1 answer
Sql date d'aujourd'hui
SQL
0 vote9.7K views1 answer
Postgresql delete type
SQL
1 vote177 views2 answers
Sql select only first occurrence
SQL
0 vote238 views1 answer
Capabilities of sql select statements
SQL
1 vote193 views1 answer
Rename table column name in mysql
SQL
0 vote201 views2 answers
Collation in sql
SQL
0 vote181 views1 answer
Azure sql server check foreign key
SQL
51 votes599 views6 answers
Installing mysql on ubuntu
SQL