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

50 votes209 views4 answers
Sql alter type of column
SQL
0 vote129 views1 answer
Get who is hired in january in sql
SQL
0 vote140 views1 answer
Access mysql database docker container shell
SQL
-2 votes141 views1 answer
Group functions in sql
SQL
1 vote149 views1 answer
Postgresql create table with timestamp
SQL
0 vote144 views2 answers
How to count codition
SQL
0 vote139 views1 answer
Gcloud check sql
SQL
3 votes172 views1 answer
Oracle apex warn on unsaved changes
SQL
5 votes156 views3 answers
Sql server utc to local
SQL
0 vote147 views1 answer
Mysql page segment
SQL