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

10 votes250 views4 answers
Drop primary key
SQL
0 vote247 views1 answer
Convert rows to columns in sql server
SQL
0 vote329 views1 answer
Compare strings lexicographically in sql
SQL
1 vote249 views2 answers
Create table if not exist
SQL
0 vote252 views1 answer
Mysql select random rows large table
SQL
0 vote193 views0 answer
SQL
0 vote556 views1 answer
Sql field equals multiple values
SQL
1 vote237 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
24 votes254 views6 answers
Alter table name sql
SQL
0 vote264 views2 answers
Get item by composite primary key mysql
SQL