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 vote244 views1 answer
How to get button for every record from mysql
SQL
0 vote227 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote222 views1 answer
Python connect microsoft sql server
SQL
1 vote248 views2 answers
Postgres select from last 3 months
SQL
3 votes226 views1 answer
Sql multi column index performance
SQL
2 votes230 views1 answer
Mysql set value as null
SQL
0 vote214 views1 answer
Mysql use password error
SQL
0 vote208 views1 answer
Oracle INTERVAL DAY to second to number
SQL
0 vote214 views4 answers
Change schema in sql server
SQL
1 vote221 views1 answer
Launch sql script from docker in mysql
SQL