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 vote231 views1 answer
Connect laravel to mysql on mac
SQL
0 vote213 views1 answer
Parsing float to int in mysql
SQL
1 vote241 views1 answer
Psql import backup file for windows
SQL
0 vote252 views1 answer
Sql to excel pgadmin
SQL
11 votes232 views5 answers
How to install sqlite3 python
SQL
0 vote237 views1 answer
Into operator in sql
SQL
0 vote234 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
5 votes226 views1 answer
How to use rank function in sql
SQL
1 vote238 views1 answer
Sql first
SQL
4 votes244 views1 answer
Postgresql list sequences
SQL