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 vote205 views1 answer
Laravel migration sql dump
SQL
0 vote201 views3 answers
How to run sql query
SQL
1 vote202 views1 answer
Oracle duration between timestamps
SQL
0 vote248 views1 answer
How to find unique element in sql
SQL
5 votes196 views1 answer
Oracle nls session
SQL
0 vote194 views2 answers
Sql trigger difference between for and after
SQL
0 vote187 views1 answer
Mysql select where text contains
SQL
1 vote152 views1 answer
Enable mysql slow query log
SQL
0 vote195 views1 answer
How to reset the database value in SQL server
SQL
0 vote201 views1 answer
Kill slow queries mysql
SQL