Northwind

Basic Index   Expanded Index

Stored Procedure:CustOrdersOrders

ParameterTypeIn/Out
@CustomerIDnchar (5)IN


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