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

2 votes332 views1 answer
Sql update alias
SQL
0 vote343 views1 answer
Get sum sqlite android
SQL
2 votes328 views2 answers
Set database timezone mysql
SQL
0 vote335 views7 answers
Les jointures sql server
SQL
0 vote324 views2 answers
Sql server select where date
SQL
5 votes353 views3 answers
Mysql remove unique constraint
SQL
1 vote341 views1 answer
Data type and their numeric form
SQL
0 vote374 views2 answers
How to get max from each department in sql
SQL
0 vote319 views1 answer
Reading from right to left from string find first special characters in sql
SQL
1 vote310 views1 answer
Mysql select row with max value group by
SQL