SQL loop with cursor

DECLARE 
    @product_name VARCHAR(MAX), 
    @list_price   DECIMAL;

DECLARE cursor_product CURSOR
FOR SELECT 
        product_name, 
        list_price
    FROM 
        production.products;

OPEN cursor_product;

FETCH NEXT FROM cursor_product INTO 
    @product_name, 
    @list_price;

WHILE @@FETCH_STATUS = 0
    BEGIN
        PRINT @product_name + CAST(@list_price AS varchar);
        FETCH NEXT FROM cursor_product INTO 
            @product_name, 
            @list_price;
    END;

CLOSE cursor_product;

DEALLOCATE cursor_product;

Similar codes

1 vote152 views1 answer
Sql week commencing date
SQL
1 vote163 views2 answers
Setval max id postgresql sequence
SQL
0 vote166 views1 answer
Mysql order by where condition sub query
SQL
0 vote143 views1 answer
Concatenate columns in table
SQL
0 vote147 views1 answer
Sql server count all tables rows
SQL
4 votes149 views2 answers
Xampp mysql database server is not starting mac m1
SQL
11 votes151 views3 answers
How to get last row of table in sql
SQL
0 vote173 views1 answer
Mysql auto increment default value with prefix month and year
SQL
6 votes103 views2 answers
Spring data jpa application.properties mysql
SQL
2 votes202 views1 answer
Brew start postgres manual
SQL