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 vote271 views1 answer
How to set field to null in sql
SQL
3 votes328 views3 answers
Restart mysql mac
SQL
0 vote311 views1 answer
RowDataPacket
SQL
0 vote370 views1 answer
Osm2pgsql mac
SQL
0 vote315 views1 answer
Sql clear table
SQL
2 votes326 views4 answers
2nd highest salary in mysql
SQL
0 vote372 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
1 vote351 views1 answer
Sql row having max
SQL
0 vote307 views1 answer
Power query case when
SQL
1 vote321 views3 answers
Rename table snowflake
SQL