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 vote163 views1 answer
Online sql testing tool
SQL
0 vote201 views1 answer
How to take sum of column with same id and different table in SQL?
SQL
1 vote188 views1 answer
Oracle turn off constraint
SQL
0 vote240 views1 answer
Cannot start database server xampp mac os
SQL
50 votes284 views6 answers
Sql count duplicate rows
SQL
0 vote169 views1 answer
Select from column mysql
SQL
0 vote199 views1 answer
How to update date value in sql
SQL
0 vote197 views1 answer
Connect laravel to mysql on mac
SQL
7 votes180 views1 answer
Buy forge mods server hosting
SQL
4 votes173 views1 answer
Oracle select first 10 rows
SQL