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

1 vote141 views1 answer
Sql server kill all connections
SQL
2 votes152 views1 answer
Insert from table tsql
SQL
0 vote134 views1 answer
Resullt all update knex mysql
SQL
1 vote175 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL
0 vote148 views1 answer
MySQL get all previous date record
SQL
3 votes138 views2 answers
Sqlite show table structure
SQL
-1 vote139 views5 answers
Convert sql to linq query online
SQL
0 vote131 views1 answer
Oracle synonym procedure
SQL
0 vote131 views1 answer
MySQL FIND_IN_SET()
SQL
7 votes137 views2 answers
Sql server drop temp table if exists
SQL