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

2 votes229 views2 answers
Sql query to copy data from one column to another
SQL
1 vote240 views1 answer
Oracle compile schema
SQL
0 vote267 views1 answer
Dynamic where clause in sql server stored procedure
SQL
0 vote255 views1 answer
How to make case insensitive in sql
SQL
0 vote241 views1 answer
How to fetch unique records from two tables
SQL
0 vote206 views1 answer
Sql runnignsum
SQL
1 vote216 views1 answer
Select random sample sql
SQL
0 vote229 views1 answer
Python mysql executemany
SQL
0 vote188 views1 answer
Msg 241, level 16, state 1, line 1 conversion failed when converting date and/or time from character string.
SQL
0 vote236 views1 answer
Mysql illegal mix of collations for operation 'concat'
SQL