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 vote153 views1 answer
Select sql in descending order
SQL
3 votes162 views1 answer
Select table column in sql
SQL
0 vote161 views1 answer
Sql use with to get value counts and percentages
SQL
13 votes174 views2 answers
Oracle inner join
SQL
0 vote162 views1 answer
Get substract count sql
SQL
0 vote153 views1 answer
SQL SERVER SELECT BETWEEN DATETIME
SQL
0 vote178 views1 answer
Sql get table last modified time
SQL
0 vote148 views1 answer
Tsql default value when no value returned by query
SQL
0 vote156 views2 answers
SQL Server Standard
SQL
0 vote165 views1 answer
Pass array parameter to stored procedure c#
SQL