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 vote161 views1 answer
Xampp import sql file command line
SQL
1 vote271 views1 answer
Aqua Data studio postgresql ssl
SQL
0 vote191 views1 answer
Set classpath for mysql-connector.jar
SQL
11 votes158 views1 answer
Oracle insert into where
SQL
35 votes193 views5 answers
Sql alter column
SQL
0 vote158 views1 answer
Get yesterday date ISO in psql
SQL
9 votes176 views2 answers
SELECT User,Host FROM mysql.user;
SQL
1 vote163 views1 answer
Oracle get current schema
SQL
2 votes233 views1 answer
Brew start postgres manual
SQL
12 votes164 views4 answers
Import mysql database command line linux
SQL