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 vote310 views2 answers
Identity column in sql server
SQL
0 vote330 views1 answer
Modifier une valeur sql
SQL
0 vote299 views1 answer
Postgresql conectar
SQL
20 votes301 views4 answers
Reset auto increment in MySQL
SQL
4 votes308 views1 answer
Phone number sql
SQL
6 votes316 views2 answers
Postgresql pg_dump
SQL
0 vote298 views1 answer
Add column to table with default value plsql
SQL
0 vote337 views1 answer
Sql: extract day text from datetime value
SQL
0 vote315 views2 answers
Cambiar nombre tabla mysql
SQL
6 votes330 views3 answers
Mysql remove user privileges
SQL