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

0 vote181 views1 answer
Manage Database in MySQL
SQL
4 votes161 views1 answer
Mac install mysql
SQL
0 vote153 views1 answer
Show database not empty tables postgres
SQL
0 vote158 views1 answer
Mysql dump everythign
SQL
0 vote154 views1 answer
Subquery aggregation
SQL
20 votes156 views2 answers
Mysql bigint max value
SQL
15 votes190 views4 answers
Export mysql db using command line
SQL
0 vote150 views1 answer
Sql join on a subquery
SQL
0 vote156 views1 answer
How to get inserted id in sql server
SQL
1 vote174 views5 answers
Sql 2nd highest salary
SQL