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 vote303 views4 answers
Postgres between dates
SQL
0 vote290 views2 answers
Tsql row number
SQL
1 vote281 views1 answer
Local sql server
SQL
0 vote296 views1 answer
Sql developer search all packages for text
SQL
4 votes283 views2 answers
Sql table
SQL
3 votes289 views1 answer
Créer une table sql
SQL
0 vote275 views1 answer
Sql get user account
SQL
1 vote277 views2 answers
Select only columns that are not empty oracle sql
SQL
0 vote287 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote293 views1 answer
Call function sql oracle with output put line
SQL