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 vote177 views1 answer
Knex last insert id mysql
SQL
6 votes197 views2 answers
How to get yesterday date in mysql
SQL
2 votes176 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote175 views1 answer
Psql use query result convert Decimal python numpy psycopg2
SQL
0 vote187 views1 answer
Python sql last insertend
SQL
0 vote208 views1 answer
Sql date with year
SQL
2 votes215 views1 answer
Mysql select true or false
SQL
0 vote176 views1 answer
Update table sql multiple set
SQL
0 vote211 views2 answers
Sql query print strings and int
SQL
4 votes185 views1 answer
Oracle session date format
SQL