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 vote186 views2 answers
How to find max and min salary in sql
SQL
-1 vote197 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
0 vote198 views1 answer
Oracle list datafiles
SQL
0 vote201 views1 answer
Sql DATE = GETDATE()
SQL
2 votes230 views1 answer
Sql string starts with
SQL
0 vote193 views1 answer
Mysql root localhost run
SQL
2 votes193 views1 answer
Sqlplus clear screen
SQL
0 vote189 views1 answer
Postgresql default value boolean
SQL
0 vote215 views1 answer
How to select only a certain date sql
SQL
8 votes182 views1 answer
Oracle add month
SQL