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

1 vote341 views4 answers
Mysqldump 1 table only
SQL
0 vote406 views1 answer
Comparing with today and yesterday record in sql query
SQL
2 votes344 views1 answer
How to get weekday from old date in sql
SQL
1 vote374 views1 answer
Round one decimal place mysql
SQL
1 vote334 views1 answer
Adding a default constraint to an existing column in sql
SQL
9 votes355 views4 answers
SQL Date Format
SQL
0 vote333 views1 answer
Sql server 2012 create or alter procedure
SQL
3 votes361 views2 answers
Postgres alter table owner
SQL
0 vote570 views1 answer
The differnece between to values in sql
SQL
1 vote387 views1 answer
Mysql find most common value
SQL