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 vote132 views1 answer
Cannot insert explicit value for identity column in table 'Tbl_Increment_File' when IDENTITY_INSERT is set to OFF.
SQL
0 vote167 views2 answers
Sql if empty then
SQL
0 vote143 views1 answer
Sql count null values in all columns
SQL
0 vote172 views2 answers
Getting customers with no orders sql
SQL
10 votes150 views2 answers
Forgot my mysql password mac
SQL
0 vote135 views1 answer
VSCode SQL Server Connection error
SQL
0 vote138 views1 answer
Sql composite key
SQL
0 vote145 views1 answer
Mysql create table like
SQL
0 vote152 views3 answers
Sql query checker
SQL
0 vote139 views1 answer
How to use group_concat in sql server
SQL