AdventureWorks2008 - procedures

Stored procedure overview

name	created	modified	params	code length	dependents	depends on	comment
uspGetBillOfMaterials	Mar 19 2009 9:10PM	Mar 19 2009 9:10PM	2	2,158	0	2	Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID.
uspGetEmployeeManagers	Mar 19 2009 9:10PM	Mar 19 2009 9:10PM	1	1,830	0	2	Stored procedure using a recursive query to return the direct and indirect managers of the specified employee.
uspGetManagerEmployees	Mar 19 2009 9:10PM	Mar 19 2009 9:10PM	1	1,785	0	2	Stored procedure using a recursive query to return the direct and indirect employees of the specified manager.
uspGetWhereUsedProductID	Mar 19 2009 9:10PM	Mar 19 2009 9:10PM	2	2,056	0	2	Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID.
uspLogError	Mar 19 2009 9:09PM	Mar 19 2009 9:09PM	1	2,075	11	2	Logs error information in the ErrorLog table about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without inserting error information.
uspPrintError	Mar 19 2009 9:09PM	Mar 19 2009 9:09PM	0	729	9	0	Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information.
uspSearchCandidateResumes	Mar 19 2009 9:10PM	Mar 19 2009 9:10PM	4	2,390	0	1	look for some resumes!
uspUpdateEmployeeHireInfo	Mar 19 2009 9:10PM	Mar 19 2009 9:10PM	7	1,183	0	4	Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.
uspUpdateEmployeeLogin	Mar 19 2009 9:10PM	Mar 19 2009 9:10PM	6	723	0	3	Updates the Employee table with the values specified in the input parameters for the given BusinessEntityID.
uspUpdateEmployeePersonalInfo	Mar 19 2009 9:10PM	Mar 19 2009 9:10PM	5	664	0	2	Updates the Employee table with the values specified in the input parameters for the given EmployeeID.