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

9 votes176 views6 answers
Oracle substring
SQL
0 vote151 views1 answer
Null column as zero in mysql
SQL
2 votes249 views1 answer
Sql ends with string
SQL
0 vote151 views1 answer
Update and keep original value sql
SQL
0 vote161 views1 answer
T sql check active deadlock
SQL
0 vote160 views1 answer
Sql python hwo to pass a list in paramerter
SQL
0 vote130 views1 answer
Ms sql unique
SQL
0 vote193 views1 answer
SQL joins in python
SQL
0 vote120 views1 answer
Store query result in variable sql
SQL
1 vote161 views1 answer
Create new table from old table
SQL