Procedure: Northwind.dbo.CustOrdersOrders

Collapse All Expand All

Procedure Properties

Name	Value
Owner	dbo
Creation Date	12/13/2004
Type	Standard T-SQL
Encrypted
ID	805577908
Implementation Type	Transact SQL

Creation options

Parameters

	Name	Description	DataType	Max Length	Type
	@CustomerID		nchar	5	Input

Recordsets returned

	Name	DataType	Max Length
	OrderID	int	4
	OrderDate	datetime	8
	RequiredDate	datetime	8
	ShippedDate	datetime	8

Objects that depend on CustOrdersOrders

Objects that CustOrdersOrders depends on

	Object Name	Object Type	Dep Level
	Orders	Table	1
	Customers	Table	2
	Employees	Table	2
	Shippers	Table	2

Total 4 object(s)

Column Level Dependencies

	Object Name	Column	Object Type
	Orders	OrderID	Table
	Orders	OrderDate	Table
	Orders	RequiredDate	Table
	Orders	ShippedDate	Table
	Orders	CustomerID	Table

Total 5 column(s)

Graphical Dependencies

Permissions

Extended Properties

SQL

SET ANSI_NULLS ON
SET QUOTED_IDENTIFIER ON
GO

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

See also

Buildmasters.com.au