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 vote112 views1 answer
Mysql, how to query the table comments?
SQL
0 vote99 views1 answer
Mysql cdn link
SQL
0 vote167 views3 answers
How to find all role in mysql
SQL
0 vote108 views1 answer
Docker ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
SQL
1 vote118 views1 answer
Mysql return if it contains
SQL
0 vote56 views1 answer
Oracle sql developer script output limit
SQL
0 vote103 views1 answer
Postgre admin slow
SQL
0 vote109 views2 answers
Temp tables in sql server
SQL
0 vote112 views1 answer
Mysql subdate
SQL
0 vote105 views2 answers
Mysql two column combination unique
SQL