Owner: | dbo |
Encrypted: | |
Creation Date: | 08/06/2000 |
Description: |
QUOTED_IDENTIFIER: | |
ANSI_NULLS: |
Name | Direction | DataType | Length | |
|
@CustomerID | INPUT | nchar | 10 |
Objects that [dbo].[CustOrdersOrders] depends on
Object Name | Owner | Object Type | Dep Level | |
|
Customers | dbo | Table | 1 |
|
Employees | dbo | Table | 1 |
|
Shippers | dbo | Table | 1 |
|
Orders | dbo | Table | 2 |
User/Role | Select | Insert | Delete | Update | Execute | DRI | |
|
public | GRANT |
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROCEDURE CustOrdersOrders @CustomerID nchar(5)
AS
SELECT OrderID,
OrderDate,
RequiredDate,
ShippedDate
FROM Orders
WHERE CustomerID = @CustomerID
ORDER BY OrderID
GO
SET QUOTED_IDENTIFIER OFF
GO
GO
SET ANSI_NULLS OFF
GO
See Also
List of stored procedures