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

14 votes388 views4 answers
Import database through command line
SQL
0 vote396 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote365 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote362 views1 answer
Oracle list subpartitions
SQL
0 vote357 views1 answer
Sql server select furst day of current year
SQL
7 votes371 views2 answers
Add column table pl sql
SQL
5 votes342 views2 answers
Oracle to_timestamp
SQL
6 votes386 views2 answers
Difference between join vs union
SQL
0 vote358 views1 answer
Select count postgres double row count > 1
SQL
1 vote399 views2 answers
Truncate table sqlite
SQL