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 vote279 views1 answer
Calculate discount from original price sql
SQL
2 votes315 views1 answer
Select * from table where name like
SQL
0 vote317 views1 answer
Postgresql alter column nullable
SQL
0 vote362 views1 answer
Insert using condition postgres
SQL
1 vote320 views2 answers
Limit sqlserver
SQL
12 votes338 views3 answers
Install sqlite driver ubuntu
SQL
2 votes350 views1 answer
Mysql trigger after update
SQL
0 vote320 views1 answer
Mysql cdn link
SQL
36 votes352 views6 answers
Delete from where sql
SQL
0 vote337 views1 answer
How to declare variable date in mysql
SQL