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

13 votes120 views2 answers
Get tables in database sql
SQL
1 vote112 views2 answers
ImportError: No module named mysql.connector
SQL
8 votes124 views1 answer
Database backup in mysql server recovery
SQL
0 vote121 views1 answer
Sql output select
SQL
0 vote115 views1 answer
Sql last 7 days
SQL
1 vote109 views1 answer
Using SQL in rails migration
SQL
0 vote114 views1 answer
Declare date variable sql
SQL
0 vote126 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote125 views1 answer
Php get closest location by latitude longitude
SQL
1 vote116 views1 answer
Mysqlworkbench Your connection attempt failed for user 'root' from your host to server at 127.0.0.1:3306: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/mysql/lib/plugin/caching_sha2_password.so, 2): image not found
SQL