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 votes195 views2 answers
Set value to null sql
SQL
31 votes129 views1 answer
Postgresql add column with constraint
SQL
0 vote150 views1 answer
Sql query inline if
SQL
0 vote137 views1 answer
Import sql in postgresql
SQL
5 votes129 views4 answers
Mysql update column with value from another table
SQL
-1 vote142 views1 answer
How to reset autoincrement in sqlite java
SQL
0 vote125 views1 answer
How to get data between a last week in mysql
SQL
0 vote130 views1 answer
Database xml sql
SQL
2 votes140 views3 answers
Sql delete duplicate
SQL
0 vote159 views1 answer
Oracle date summer time
SQL