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 vote325 views1 answer
Cross schema query oracle 2 users
SQL
24 votes311 views2 answers
Alter table delete column
SQL
0 vote310 views1 answer
Mysql insert into select with recursive
SQL
0 vote340 views1 answer
Mysql config address
SQL
0 vote346 views1 answer
MySQL update with subquery
SQL
1 vote330 views1 answer
Replace all numbers in mysql
SQL
0 vote322 views1 answer
Sql server change schema of a table
SQL
2 votes339 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote312 views1 answer
Azure sql server check foreign key
SQL
0 vote337 views1 answer
Nuget sqllite-net-pcl
SQL