Properties

Owner: dbo 
Encrypted:  
Creation Date: 08/06/2000 
Description:  

Creation options

QUOTED_IDENTIFIER:  
ANSI_NULLS:  

Parameters

Name Direction DataType Length
  @CustomerID  INPUT  nchar  10 
Total: 1 parameter(s)

Objects that [dbo].[CustOrdersOrders] depends on

Object Name Owner Object Type Dep Level
  Customers  dbo  Table 
  Employees  dbo  Table 
  Shippers  dbo  Table 
  Orders  dbo  Table 
Total: 4 object(s)

Permissions

User/Role Select Insert Delete Update Execute DRI
  public          GRANT   
Total: 1 permission(s)

SQL

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