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

6 votes213 views4 answers
Mysql get random row
SQL
2 votes245 views3 answers
3 days back in sql server
SQL
0 vote222 views1 answer
Automated psql csv export script on windows
SQL
1 vote138 views1 answer
Athena query timestamp greater than
SQL
0 vote139 views1 answer
Postgresql subquery
SQL
6 votes166 views1 answer
Rank function in oracle with example
SQL
1 vote176 views1 answer
Rails run native ssql query
SQL
6 votes175 views4 answers
Sqlite drop table
SQL
1 vote179 views1 answer
Oracle sql create or replace view
SQL
25 votes207 views6 answers
How to change column name in mysql
SQL