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 vote145 views2 answers
Suse Linux restart MySQL
SQL
46 votes183 views4 answers
Create column sql
SQL
0 vote120 views1 answer
Incorrect string value: mysql
SQL
0 vote122 views1 answer
Ffeathers express mysql application users login
SQL
0 vote119 views1 answer
Select the date 30 days less that the todays date sql request
SQL
7 votes81 views1 answer
Alter table add key sql
SQL
0 vote124 views1 answer
Sql find all different values in column
SQL
18 votes78 views2 answers
How to get all the tables displayed in oracle
SQL
0 vote167 views1 answer
Add user mysql wordpress
SQL
0 vote128 views1 answer
How to create a table based on another table in mysql
SQL