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

0 vote130 views1 answer
Get last run query sql server
SQL
3 votes177 views1 answer
Locate sql server
SQL
2 votes171 views1 answer
While loop sql
SQL
1 vote203 views1 answer
Oracle plan hash value
SQL
3 votes176 views2 answers
Install mysql powershell
SQL
0 vote165 views1 answer
Query on date sqlite flutter
SQL
0 vote168 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
1 vote171 views1 answer
Generate random data postgresql
SQL
5 votes223 views1 answer
Dbms_metadata.get_ddl table
SQL
0 vote192 views1 answer
Query for backup a database at another location in file system
SQL