AdventureWorks2008 - procedure parameters

All procedure parameters

procedure	type	parameter	datatype	length	in/out	comment
uspGetBillOfMaterials	P	@StartProductID	int	4	IN	Input parameter for the stored procedure uspGetBillOfMaterials. Enter a valid ProductID from the Production.Product table.
uspGetBillOfMaterials	P	@CheckDate	datetime	8	IN	Input parameter for the stored procedure uspGetBillOfMaterials used to eliminate components not used after that date. Enter a valid date. Or not, your choice.
uspGetEmployeeManagers	P	@BusinessEntityID	int	4	IN	Input parameter for the stored procedure uspGetEmployeeManagers. Enter a valid BusinessEntityID from the HumanResources.Employee table.
uspGetManagerEmployees	P	@BusinessEntityID	int	4	IN	Input parameter for the stored procedure uspGetManagerEmployees. Enter a valid BusinessEntityID of the manager from the HumanResources.Employee table.
uspGetWhereUsedProductID	P	@StartProductID	int	4	IN	Input parameter for the stored procedure uspGetWhereUsedProductID. Enter a valid ProductID from the Production.Product table.
uspGetWhereUsedProductID	P	@CheckDate	datetime	8	IN	Input parameter for the stored procedure uspGetWhereUsedProductID used to eliminate components not used after that date. Enter a valid date.
uspLogError	P	@ErrorLogID	int	4	INOUT	Output parameter for the stored procedure uspLogError. Contains the ErrorLogID value corresponding to the row inserted by uspLogError in the ErrorLog table.
uspSearchCandidateResumes	P	@searchString	nvarchar	1000	IN
uspSearchCandidateResumes	P	@useInflectional	bit	0	IN
uspSearchCandidateResumes	P	@useThesaurus	bit	0	IN
uspSearchCandidateResumes	P	@language	int	4	IN
uspUpdateEmployeeHireInfo	P	@BusinessEntityID	int	4	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid BusinessEntityID from the Employee table.
uspUpdateEmployeeHireInfo	P	@JobTitle	nvarchar	50	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a title for the employee.
uspUpdateEmployeeHireInfo	P	@HireDate	datetime	8	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a hire date for the employee.
uspUpdateEmployeeHireInfo	P	@RateChangeDate	datetime	8	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the date the rate changed for the employee.
uspUpdateEmployeeHireInfo	P	@Rate	money	8	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the new rate for the employee.
uspUpdateEmployeeHireInfo	P	@PayFrequency	tinyint	1	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the pay frequency for the employee.
uspUpdateEmployeeHireInfo	P	@CurrentFlag	bit	0	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee.
uspUpdateEmployeeLogin	P	@BusinessEntityID	int	4	IN	Input parameter for the stored procedure uspUpdateEmployeeLogin. Enter a valid EmployeeID from the Employee table.
uspUpdateEmployeeLogin	P	@OrganizationNode	hierarchyid	892	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid ManagerID for the employee.
uspUpdateEmployeeLogin	P	@LoginID	nvarchar	256	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid login for the employee.
uspUpdateEmployeeLogin	P	@JobTitle	nvarchar	50	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a title for the employee.
uspUpdateEmployeeLogin	P	@HireDate	datetime	8	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a hire date for the employee.
uspUpdateEmployeeLogin	P	@CurrentFlag	bit	0	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee.
uspUpdateEmployeePersonalInfo	P	@BusinessEntityID	int	4	IN	Input parameter for the stored procedure uspUpdateEmployeePersonalInfo. Enter a valid BusinessEntityID from the HumanResources.Employee table.
uspUpdateEmployeePersonalInfo	P	@NationalIDNumber	nvarchar	15	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a national ID for the employee.
uspUpdateEmployeePersonalInfo	P	@BirthDate	datetime	8	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a birth date for the employee.
uspUpdateEmployeePersonalInfo	P	@MaritalStatus	nchar	1	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a marital status for the employee.
uspUpdateEmployeePersonalInfo	P	@Gender	nchar	1	IN	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a gender for the employee.
ufnGetAccountingEndDate	FN		datetime	8	OUT
ufnGetAccountingStartDate	FN		datetime	8	OUT
ufnGetDocumentStatusText	FN		nvarchar	16	OUT
ufnGetDocumentStatusText	FN	@Status	tinyint	1	IN	Input parameter for the scalar function ufnGetDocumentStatusText. Enter a valid integer.
ufnGetProductDealerPrice	FN		money	8	OUT
ufnGetProductDealerPrice	FN	@ProductID	int	4	IN	Input parameter for the scalar function ufnGetProductDealerPrice. Enter a valid ProductID from the Production.Product table.
ufnGetProductDealerPrice	FN	@OrderDate	datetime	8	IN	Input parameter for the scalar function ufnGetProductDealerPrice. Enter a valid order date.
ufnGetProductListPrice	FN		money	8	OUT
ufnGetProductListPrice	FN	@ProductID	int	4	IN	Input parameter for the scalar function ufnGetProductListPrice. Enter a valid ProductID from the Production.Product table.
ufnGetProductListPrice	FN	@OrderDate	datetime	8	IN	Input parameter for the scalar function ufnGetProductListPrice. Enter a valid order date.
ufnGetProductStandardCost	FN		money	8	OUT
ufnGetProductStandardCost	FN	@ProductID	int	4	IN	Input parameter for the scalar function ufnGetProductStandardCost. Enter a valid ProductID from the Production.Product table.
ufnGetProductStandardCost	FN	@OrderDate	datetime	8	IN	Input parameter for the scalar function ufnGetProductStandardCost. Enter a valid order date.
ufnGetPurchaseOrderStatusText	FN		nvarchar	15	OUT
ufnGetPurchaseOrderStatusText	FN	@Status	tinyint	1	IN	Input parameter for the scalar function ufnGetPurchaseOrdertStatusText. Enter a valid integer.
ufnGetSalesOrderStatusText	FN		nvarchar	15	OUT
ufnGetSalesOrderStatusText	FN	@Status	tinyint	1	IN	Input parameter for the scalar function ufnGetSalesOrderStatusText. Enter a valid integer.
ufnGetStock	FN		int	4	OUT
ufnGetStock	FN	@ProductID	int	4	IN	Input parameter for the scalar function ufnGetStock. Enter a valid ProductID from the Production.ProductInventory table.
ufnLeadingZeros	FN		varchar	8	OUT
ufnLeadingZeros	FN	@Value	int	4	IN	Input parameter for the scalar function ufnLeadingZeros. Enter a valid integer.
ufnGetContactInformation	TF	@PersonID	int	4	IN	Input parameter for the table value function ufnGetContactInformation. Enter a valid PersonID from the Person.Contact table.