AdventureWorks - procedures

Stored procedure overview

name	created	modified	params	code length	dependents	depends on	comment
uspGetBillOfMaterials	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	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:08PM	Mar 19 2009 9:08PM	1	1,625	0	2	Stored procedure using a recursive query to return the direct and indirect managers of the specified employee.
uspGetManagerEmployees	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	1	1,614	0	2	Stored procedure using a recursive query to return the direct and indirect employees of the specified manager.
uspGetWhereUsedProductID	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	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:08PM	Mar 19 2009 9:08PM	1	2,075	12	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:08PM	Mar 19 2009 9:08PM	0	729	10	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.
uspUpdateEmployeeHireInfo	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	7	1,144	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:08PM	Mar 19 2009 9:08PM	6	667	0	3	Updates the Employee table with the values specified in the input parameters for the given EmployeeID.
uspUpdateEmployeePersonalInfo	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	5	646	0	2	Updates the Employee table with the values specified in the input parameters for the given EmployeeID.