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 vote141 views1 answer
How to inner join 4 tables in sql
SQL
0 vote146 views1 answer
Mysql value ends with
SQL
0 vote127 views1 answer
How to print mysql query of codeigniter query builder
SQL
0 vote137 views1 answer
Mysql docker image arjun
SQL
0 vote129 views1 answer
Selects all the columns from the sailors table
SQL
0 vote161 views3 answers
Get count of null in column sql
SQL
0 vote134 views1 answer
Postgresql if else endif
SQL
0 vote213 views2 answers
Disadvantages of stored procedures sql
SQL
15 votes158 views4 answers
Sql update from select
SQL
1 vote145 views1 answer
Create index concurrently postgres
SQL