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 vote326 views1 answer
View acl table oracle
SQL
0 vote325 views1 answer
Error-expression-select-list-not-group-by-nonaggregated-column/
SQL
1 vote331 views1 answer
Show table status command in mysql
SQL
0 vote342 views1 answer
Edit shchima table in sql
SQL
61 votes544 views6 answers
Mysql add column
SQL
11 votes368 views1 answer
Ddl view
SQL
0 vote340 views2 answers
How to tun mysql on ubunto
SQL
0 vote335 views1 answer
Mysql use password error
SQL
0 vote371 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
1 vote351 views1 answer
Select last row from SQL Table
SQL