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 votes284 views2 answers
Sql percentage
SQL
0 vote305 views1 answer
Mysql get hour from datetime
SQL
0 vote270 views1 answer
Sum value by month sql
SQL
0 vote287 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
13 votes289 views2 answers
Sql join 3 tables
SQL
0 vote332 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote292 views1 answer
Psql store procedure-return multiple table values
SQL
1 vote290 views1 answer
Mysql add fields
SQL
0 vote275 views1 answer
Modificar tipo de dato sql server
SQL
1 vote307 views1 answer
Sqlalchemy on delete set null
SQL