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 vote183 views1 answer
Reutrn string after character sql
SQL
-1 vote181 views2 answers
Postgresql user permissions to database
SQL
0 vote241 views1 answer
Mysql error 1114 (hy000) the table is full
SQL
0 vote189 views1 answer
Mysql shell set time_zone
SQL
0 vote192 views1 answer
C# get sql min date
SQL
0 vote194 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
4 votes178 views1 answer
Mysql copy table with new name
SQL
0 vote221 views1 answer
Compress sql file database ubuntu
SQL
0 vote186 views1 answer
Contact mysql column field
SQL
5 votes220 views1 answer
Ascending order and where in sql
SQL