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

2 votes198 views1 answer
Get hour from date sql
SQL
45 votes279 views5 answers
Grant all privileges mysql
SQL
2 votes241 views1 answer
How to get non distinct values in sql
SQL
0 vote153 views1 answer
Now() -1 mysql
SQL
0 vote208 views2 answers
Postgresql gset
SQL
2 votes205 views1 answer
Node and mysql like
SQL
3 votes193 views2 answers
Install mysql powershell
SQL
0 vote215 views1 answer
For row in sql database python loop
SQL
10 votes201 views2 answers
Show tables in schema oracle
SQL
0 vote197 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL