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. |