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

28 votes150 views6 answers
Mysql change user password
SQL
0 vote161 views1 answer
Hotw to alter lengh character vayng postgres
SQL
0 vote142 views1 answer
Failed to connect to localhost:1433 - self signed certificate
SQL
3 votes155 views1 answer
Insert into table from another table mysql
SQL
0 vote147 views1 answer
Postgres create extension if not exists
SQL
0 vote214 views1 answer
Sql select max value for each group
SQL
0 vote155 views2 answers
How to find max and min salary in sql
SQL
0 vote158 views1 answer
How to input data as id in database sql c#
SQL
0 vote154 views1 answer
Consecutive numbers sql
SQL
0 vote152 views1 answer
Replace content value from old to new sql
SQL