List of Procedures

Name Schema Description Modify Date Create Date Encrypted
procedures key icon aa dbo 12/23/2010 8:07:43 AM 12/23/2010 8:07:43 AM false
procedures key icon bb dbo 12/23/2010 8:23:37 AM 12/23/2010 8:23:37 AM false
procedures key icon sp_alterdiagram dbo 6/20/2011 3:16:00 PM 6/20/2011 3:16:00 PM false
procedures key icon sp_creatediagram dbo 6/20/2011 3:16:00 PM 6/20/2011 3:16:00 PM false
procedures key icon sp_dropdiagram dbo 6/20/2011 3:16:00 PM 6/20/2011 3:16:00 PM false
procedures key icon sp_helpdiagramdefinition dbo 6/20/2011 3:16:00 PM 6/20/2011 3:16:00 PM false
procedures key icon sp_helpdiagrams dbo 6/20/2011 3:16:00 PM 6/20/2011 3:16:00 PM false
procedures key icon sp_renamediagram dbo 6/20/2011 3:16:00 PM 6/20/2011 3:16:00 PM false
procedures key icon sp_t dbo 12/22/2010 11:07:45 PM 12/22/2010 11:07:45 PM false
procedures key icon sp_upgraddiagrams dbo 6/20/2011 3:15:59 PM 6/20/2011 3:15:59 PM false
procedures key icon usp_b dbo 1/21/2011 2:57:26 AM 1/21/2011 2:57:26 AM false
procedures key icon usp_delete_t99 dbo 12/18/2011 2:06:28 PM 12/18/2011 2:06:28 PM false
procedures key icon usp_testddl dbo 7/22/2011 7:34:46 PM 7/22/2011 7:34:46 PM false
procedures key icon uspCurrencyCursor dbo mobi uspCurencyCursor 12/23/2010 8:11:33 AM 12/23/2010 8:11:33 AM false
procedures key icon uspGetBillOfMaterials dbo Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID. 8/8/2010 5:23:46 PM 8/8/2010 5:23:46 PM false
procedures key icon uspGetEmployeeManagers dbo Stored procedure using a recursive query to return the direct and indirect managers of the specified employee. 8/8/2010 5:23:46 PM 8/8/2010 5:23:46 PM false
procedures key icon uspGetManagerEmployees dbo Stored procedure using a recursive query to return the direct and indirect employees of the specified manager. 8/8/2010 5:23:46 PM 8/8/2010 5:23:46 PM false
procedures key icon uspGetWhereUsedProductID dbo Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID. 8/8/2010 5:23:46 PM 8/8/2010 5:23:46 PM false
procedures key icon uspLogError dbo 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. 8/8/2010 5:21:43 PM 8/8/2010 5:21:43 PM false
procedures key icon uspPrintError dbo 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. 8/8/2010 5:21:43 PM 8/8/2010 5:21:43 PM false
procedures key icon uspSearchCandidateResumes dbo 8/8/2010 5:23:47 PM 8/8/2010 5:23:47 PM false
procedures key icon uspUpdateEmployeeHireInfo HumanResources Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. 8/8/2010 5:23:46 PM 8/8/2010 5:23:46 PM false
procedures key icon uspUpdateEmployeeLogin HumanResources Updates the Employee table with the values specified in the input parameters for the given BusinessEntityID. 8/8/2010 5:23:47 PM 8/8/2010 5:23:47 PM false
procedures key icon uspUpdateEmployeePersonalInfo HumanResources Updates the Employee table with the values specified in the input parameters for the given EmployeeID. 8/8/2010 5:23:47 PM 8/8/2010 5:23:47 PM false
procedures key icon uspGetList Production 12/23/2010 6:58:48 AM 12/23/2010 6:58:48 AM false