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

10 votes379 views4 answers
SELECT FROM WHERE
SQL
1 vote358 views2 answers
Mysql filter by date mount
SQL
0 vote339 views1 answer
Sql combine results from two tables
SQL
11 votes356 views1 answer
Oracle view ddl
SQL
0 vote331 views1 answer
Sql right characters
SQL
8 votes339 views1 answer
Mysql restore database
SQL
0 vote382 views1 answer
Typical max-connect-errors mysql
SQL
3 votes356 views1 answer
Sql server version query
SQL
0 vote487 views1 answer
Postgresql powershell query
SQL
0 vote336 views1 answer
Postgres select except
SQL