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

2 votes251 views2 answers
Change mysql password from command line
SQL
0 vote247 views4 answers
Mysql replace regex
SQL
0 vote256 views1 answer
Mysql search multiple tables
SQL
0 vote219 views1 answer
Deleted table in sql trigger
SQL
2 votes245 views1 answer
Sql ignore accents
SQL
3 votes283 views1 answer
Laravel paginate raw sql
SQL
0 vote273 views1 answer
Influxdb clone measurement
SQL
2 votes263 views1 answer
Oracle drop sequence if exists
SQL
3 votes251 views1 answer
How to uninstall microsoft sql server
SQL
0 vote288 views2 answers
Mysql insert into multiple tables
SQL