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

1 vote340 views1 answer
Oracle stop
SQL
3 votes333 views2 answers
Oracle drop column
SQL
0 vote344 views1 answer
How to install postgresql on wsl
SQL
0 vote336 views1 answer
How to read the potentail error messages in ssis package
SQL
4 votes317 views2 answers
Tables in sql
SQL
11 votes348 views1 answer
Oracle view source
SQL
22 votes403 views1 answer
Mysql workbench
SQL
0 vote336 views2 answers
How to type a blank discord messgae
SQL
1 vote313 views1 answer
Import in mysql without a software
SQL
0 vote339 views1 answer
How to create a table based on another table in mysql
SQL