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 vote123 views1 answer
Set autoincrement to 0
SQL
0 vote133 views1 answer
Authentication modes in sql server
SQL
7 votes125 views3 answers
Foreign key oracle
SQL
2 votes120 views2 answers
Laravel query builder toSql
SQL
0 vote131 views1 answer
Postgres grep entire database
SQL
2 votes125 views5 answers
Eloquest how to select one specific column in database
SQL
3 votes238 views6 answers
Sql unique select
SQL
0 vote184 views1 answer
How to get number of months between 2 dates sql server
SQL
0 vote107 views2 answers
Add new column after in sql
SQL
0 vote138 views1 answer
Postgres get database encoding
SQL