Stored Procedures Stored Procedures
NameDescription
dbo.uspGetBillOfMaterialsStored procedure using a recursive query to return a multi-level bill of material for the specified ProductID.
dbo.uspGetEmployeeManagersStored procedure using a recursive query to return the direct and indirect managers of the specified employee.
dbo.uspGetManagerEmployeesStored procedure using a recursive query to return the direct and indirect employees of the specified manager.
dbo.uspGetWhereUsedProductIDStored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID.
dbo.uspLogErrorLogs 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.uspPrintErrorPrints 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.uspUpdateEmployeeHireInfoUpdates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.
HumanResources.uspUpdateEmployeeLoginUpdates the Employee table with the values specified in the input parameters for the given BusinessEntityID.
HumanResources.uspUpdateEmployeePersonalInfoUpdates the Employee table with the values specified in the input parameters for the given EmployeeID.