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 vote119 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
-1 vote102 views3 answers
Create temp table in sql
SQL
10 votes111 views4 answers
Mysql one week ago
SQL
24 votes107 views4 answers
Postgres remove database
SQL
0 vote107 views1 answer
N file included from src/buffer.cpp:12: src/pyodbc.h:56:10: fatal error: 'sql.h' file not found #include <sql.h>
SQL
9 votes117 views4 answers
Oracle get table column names
SQL
9 votes252 views2 answers
Current date in postgresql minus 1 day
SQL
0 vote121 views1 answer
Copy column from one table to another without column duplicate postgres
SQL
0 vote103 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
13 votes100 views2 answers
Mysql order by multiple columns
SQL