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 vote242 views1 answer
How to show current database in mysql
SQL
18 votes159 views3 answers
Mysql current date
SQL
0 vote166 views1 answer
Delete insert record in sql server
SQL
-1 vote159 views1 answer
Export mysql table to file
SQL
5 votes180 views3 answers
Oracle first day of last year
SQL
0 vote184 views1 answer
Acutal month year
SQL
1 vote169 views1 answer
Psql connect to another database
SQL
0 vote166 views1 answer
Use between operator in mysql
SQL
0 vote195 views1 answer
Java nosql sort
SQL
0 vote188 views1 answer
Sql use with to get value counts and percentages
SQL