بله

IF (@QuantityOrdered < (SELECT QuantityOnHand

                  FROM Inventory

                  WHERE PartID = @PartOrdered) )

   BEGIN

   -- SQL statements to update tables and process order.

   END

ELSE

   BEGIN

   -- SELECT statement to retrieve the IDs of alternate items

   -- to suggest as replacements to the customer.

   END