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 vote330 views2 answers
Mysql get day of week
SQL
0 vote298 views3 answers
Sql drop all tables
SQL
0 vote279 views1 answer
How to to get current date and time in sql
SQL
1 vote269 views1 answer
Autocommit mysql
SQL
7 votes274 views1 answer
Grant schema permissions postgres
SQL
6 votes306 views2 answers
Psql load dump
SQL
14 votes318 views2 answers
Oracle limit rows
SQL
0 vote306 views1 answer
QCompleter con sql
SQL
1 vote286 views1 answer
Postgres count string length
SQL
0 vote327 views1 answer
Netstat -tln mysql
SQL