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

4 votes145 views2 answers
Show all database inside postgresql
SQL
0 vote243 views1 answer
How to find the most occuring in SQL
SQL
0 vote144 views3 answers
Condition in count sql
SQL
0 vote104 views2 answers
Avg() sql
SQL
0 vote148 views1 answer
Pagination with row_number
SQL
0 vote170 views2 answers
Nested query
SQL
12 votes142 views2 answers
Insert multiple rows from another table sql
SQL
0 vote163 views1 answer
For row in sql database python loop
SQL
0 vote160 views2 answers
What is the default password for sql server sa
SQL
0 vote136 views1 answer
Postgres call view
SQL