LISTING 1: Stored Procedure That Returns a List of Products

CREATE PROCEDURE getOrderList
   @minDate DateTime
AS
-- Select orders on or after the specified date.
SELECT OrderID, OrderDate
FROM Orders
WHERE OrderDate >= @minDate
ORDER BY OrderDate
GO