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 vote353 views3 answers
Run sql command line
SQL
25 votes354 views3 answers
How to use a database to see tables mysql
SQL
2 votes344 views4 answers
2nd highest salary in mysql
SQL
3 votes363 views2 answers
Check data in table mysql
SQL
0 vote344 views1 answer
Proc sql not in working
SQL
2 votes311 views1 answer
Install sqlite npm
SQL
0 vote316 views1 answer
Renommer schema sql
SQL
23 votes349 views6 answers
How to create table in sql
SQL
0 vote333 views1 answer
Mysql drop vs delete
SQL
0 vote328 views1 answer
Mysql select where field is a value
SQL