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 vote203 views1 answer
How to select only a certain date sql
SQL
7 votes194 views3 answers
Postgresql dump and restore db
SQL
7 votes200 views1 answer
Minecraft forge server host
SQL
2 votes226 views1 answer
Power query concatenate
SQL
2 votes228 views2 answers
Calculate percentage in sql
SQL
1 vote305 views2 answers
Truncate table sqlite
SQL
1 vote217 views1 answer
Isnull sql server
SQL
3 votes221 views1 answer
Start mysql server by terminal in linux
SQL
0 vote199 views1 answer
Postgresql alter column nullable
SQL
4 votes198 views2 answers
Mysql select where starts with
SQL