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

3 votes221 views1 answer
Query less than datetime sql
SQL
1 vote209 views1 answer
How to make a select in sql
SQL
0 vote208 views1 answer
Sum value by month sql
SQL
0 vote252 views1 answer
How to enable mysql 5.7 root user password on linux
SQL
0 vote231 views1 answer
Report in database
SQL
1 vote284 views1 answer
Postgresql can you have null foreign key
SQL
3 votes224 views2 answers
Install mysql powershell
SQL
8 votes250 views1 answer
Mysql limit rows
SQL
1 vote220 views1 answer
Trigger in postgresql to change incoming entry
SQL
-1 vote237 views2 answers
Import data from excel to sql server automatically
SQL