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

22 votes196 views3 answers
Remove all records from table mysql
SQL
2 votes186 views1 answer
Update trigger
SQL
2 votes217 views1 answer
Sql count having
SQL
0 vote181 views1 answer
Csv to sqlite python
SQL
0 vote174 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote149 views1 answer
Expose db in virtualbox
SQL
2 votes187 views2 answers
Mysql get time from datetime
SQL
12 votes186 views1 answer
Script to add new column in table sql
SQL
49 votes262 views6 answers
Alter table add column
SQL
0 vote255 views1 answer
Sql delete caracter list
SQL