100 Days of SQL

Day 91 – Cursors

DECLARE @OrderID INT
DECLARE @ProductID INT
DECLARE @Quantity INT

DECLARE order_cursor CURSOR FOR
SELECT OrderID, ProductID, Quantity FROM OrderDetails

OPEN order_cursor

FETCH NEXT FROM order_cursor INTO @OrderID, @ProductID, @Quantity

WHILE @@FETCH_STATUS = 0
BEGIN
    IF @Quantity > 10
    BEGIN
        PRINT 'Order ID: ' + CAST(@OrderID AS VARCHAR(10)) + ', Product ID: ' + CAST(@ProductID AS VARCHAR(10)) + ', Quantity: ' + CAST(@Quantity AS VARCHAR(10))
    END
    FETCH NEXT FROM order_cursor INTO @OrderID, @ProductID, @Quantity
END

CLOSE order_cursor
DEALLOCATE order_cursor

In this example, a cursor named order_cursor is used to retrieve the OrderID, `