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 vote197 views2 answers
Postgresql create role
SQL
8 votes222 views1 answer
Oracle search stored procedures for text
SQL
8 votes219 views10 answers
Sql
SQL
0 vote242 views1 answer
How to change mysql root password in windows 10
SQL
52 votes336 views6 answers
Rename column sql
SQL
0 vote216 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
3 votes200 views1 answer
Show index table
SQL
2 votes206 views2 answers
Checking data type in sql server
SQL
0 vote264 views1 answer
ALV GRID events
SQL
0 vote226 views1 answer
Spring Flyway Teams Edition or MySQL upgrade required: MySQL 5.5 is no longer supported by Flyway Community Edition, but still supported by Flyway Teams Edition.
SQL