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 vote131 views1 answer
Mysql root permission denied lost
SQL
1 vote134 views1 answer
Mysql how to truncate table with foreign keys
SQL
0 vote132 views1 answer
Grant owner postgresql
SQL
0 vote137 views1 answer
Select insert new table sql server
SQL
0 vote116 views1 answer
Mysql update sequence with order by
SQL
0 vote121 views1 answer
Mysql create table columns with spaces
SQL
1 vote126 views1 answer
Psql connections
SQL
5 votes123 views1 answer
Sql check if date is between 2 dates
SQL
0 vote114 views2 answers
Add new column after in sql
SQL
0 vote126 views1 answer
Mysql date format unix timestamp
SQL