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 vote286 views1 answer
Postgresql linux password
SQL
0 vote287 views1 answer
Kill mysqld_safe process mariadb
SQL
0 vote295 views1 answer
Drop tables from local database postgres pgadmin
SQL
6 votes278 views3 answers
Date_trunc postgres
SQL
0 vote267 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
1 vote206 views1 answer
Convert money to varchar sql server
SQL
0 vote257 views1 answer
Oracle select invalid views
SQL
0 vote279 views2 answers
Sql trigger difference between for and after
SQL
0 vote260 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote272 views1 answer
Drop specific row postgresql
SQL