USE AdventureWorksCycles;

EXEC DeleteOrder
    @OrderID = 4;                -- the order id to delete