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 vote260 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
2 votes261 views1 answer
Sqlite insert if not exists
SQL
1 vote257 views2 answers
Populate sql table with random data
SQL
0 vote261 views1 answer
Like sql for second letter of the family name
SQL
1 vote261 views1 answer
Select 2 rows in sql
SQL
3 votes338 views1 answer
Apex call duration
SQL
0 vote248 views1 answer
Sql view index
SQL
0 vote273 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL
0 vote252 views1 answer
Raiserror nowait sql server
SQL
11 votes274 views3 answers
Pl sql example
SQL