Northwind Database Documentation  

CustOrdersOrders Stored Procedure

Description

 

Parameters

Name Type Direction Description
 @CustomerID nchar(5) Input  

Definition


CREATE PROCEDURE CustOrdersOrders @CustomerID nchar(5)
AS
SELECT OrderID,
    OrderDate,
    RequiredDate,
    ShippedDate
FROM Orders
WHERE CustomerID = @CustomerID
ORDER BY OrderID

See Also

Tables | Views | Stored Procedures