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 vote237 views1 answer
How to add timestamp column in mysql
SQL
0 vote222 views1 answer
Oracle index hint
SQL
1 vote310 views1 answer
Aqua Data studio postgresql ssl
SQL
2 votes241 views1 answer
Postgresql create table as select
SQL
-1 vote245 views1 answer
Sql show custom constraints
SQL
-1 vote225 views2 answers
Sql convert date to string yyyy-mm-dd
SQL
2 votes228 views2 answers
Sql first character
SQL
0 vote203 views1 answer
Sqlite3 not commit
SQL
0 vote225 views1 answer
Show size of all tables postgres
SQL
0 vote217 views1 answer
Sql count null as 0
SQL