| Name | Description |
|---|
| dbo.uspGetBillOfMaterials | Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID. |
| dbo.uspGetEmployeeManagers | Stored procedure using a recursive query to return the direct and indirect managers of the specified employee. |
| dbo.uspGetManagerEmployees | Stored procedure using a recursive query to return the direct and indirect employees of the specified manager. |
| dbo.uspGetWhereUsedProductID | Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID. |
| dbo.uspLogError | 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. |
| dbo.uspPrintError | 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. |
| dbo.uspSearchCandidateResumes | |
| HumanResources.uspUpdateEmployeeHireInfo | Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. |
| HumanResources.uspUpdateEmployeeLogin | Updates the Employee table with the values specified in the input parameters for the given BusinessEntityID. |
| HumanResources.uspUpdateEmployeePersonalInfo | Updates the Employee table with the values specified in the input parameters for the given EmployeeID. |
Stored Procedures
