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

0 vote142 views1 answer
Sql shell psql cannot enter password
SQL
0 vote136 views1 answer
Postgres create extension if not exists
SQL
0 vote148 views1 answer
Disable database droping sql
SQL
1 vote137 views1 answer
Mysql average of multiple columns
SQL
20 votes150 views4 answers
Reset auto increment in MySQL
SQL
0 vote129 views1 answer
Oracle index hint multiple tables example
SQL
1 vote138 views2 answers
Oracle create synonym
SQL
0 vote132 views1 answer
Mysql update sum same table
SQL
1 vote150 views1 answer
Sql drop schema
SQL
2 votes135 views1 answer
Mysql set value as null
SQL