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 vote274 views1 answer
How to switch user in mysql
SQL
4 votes301 views1 answer
Sql delete multiple conditions
SQL
18 votes276 views6 answers
Laravel form validation
SQL
0 vote286 views1 answer
PDOException: SQLSTATE[HY093]: Invalid parameter numb
SQL
0 vote267 views1 answer
Oracle date summer time
SQL
2 votes295 views3 answers
Sql truncate table
SQL
1 vote287 views1 answer
Postgresql round double precision
SQL
0 vote268 views1 answer
Sql find leading space
SQL
1 vote277 views2 answers
Postgres cast as decimal
SQL
0 vote292 views1 answer
Flask sqlalchemy. commit does not save changes
SQL