|
[dbo].[sp_alterdiagram]
|
Jan 5 2008 7:23AM |
Jan 5 2008 7:23AM |
4 |
1,565 |
0 |
2 |
|
|
[dbo].[sp_creatediagram]
|
Jan 5 2008 7:23AM |
Jan 5 2008 7:23AM |
4 |
1,280 |
0 |
2 |
|
|
[dbo].[sp_dropdiagram]
|
Jan 5 2008 7:23AM |
Jan 5 2008 7:23AM |
2 |
936 |
0 |
2 |
|
|
[dbo].[sp_helpdiagramdefinition]
|
Jan 5 2008 7:23AM |
Jan 5 2008 7:23AM |
2 |
960 |
0 |
2 |
|
|
[dbo].[sp_helpdiagrams]
|
Jan 5 2008 7:23AM |
Jan 5 2008 7:23AM |
2 |
688 |
0 |
2 |
|
|
[dbo].[sp_renamediagram]
|
Jan 5 2008 7:23AM |
Jan 5 2008 7:23AM |
3 |
1,782 |
0 |
2 |
|
|
[dbo].[sp_upgraddiagrams]
|
Jan 5 2008 7:23AM |
Jan 5 2008 7:23AM |
0 |
1,522 |
0 |
1 |
|
|
[dbo].[usp_CreateContact]
|
Aug 5 2006 4:42PM |
Aug 5 2006 4:42PM |
3 |
0 |
0 |
2 |
does this proc really need to exist? Don't think so!
|
|
[dbo].[usp_LookupConversionRate]
|
Aug 5 2006 4:42PM |
Aug 5 2006 4:42PM |
3 |
865 |
0 |
2 |
|
|
[dbo].[uspGetBillOfMaterials]
|
Oct 14 2005 2:00AM |
Oct 14 2005 2:00AM |
2 |
2,158 |
0 |
3 |
Stored procedure using a recursive query to return a multi-level bill of material for the specified ProductID.
|
|
[dbo].[uspGetEmployeeManagers]
|
Oct 14 2005 2:00AM |
Oct 14 2005 2:00AM |
1 |
1,625 |
0 |
3 |
Stored procedure using a recursive query to return the direct and indirect managers of the specified employee.
|
|
[dbo].[uspGetManagerEmployees]
|
Oct 14 2005 2:00AM |
Oct 14 2005 2:00AM |
1 |
1,614 |
0 |
3 |
Stored procedure using a recursive query to return the direct and indirect employees of the specified manager.
|
|
[dbo].[uspGetPersonInfo]
|
Feb 20 2008 9:07PM |
Feb 20 2008 9:07PM |
1 |
215 |
0 |
2 |
|
|
[dbo].[uspGetWhereUsedProductID]
|
Oct 14 2005 2:00AM |
Oct 14 2005 2:00AM |
2 |
2,056 |
0 |
3 |
Stored procedure using a recursive query to return all components or assemblies that directly or indirectly use the specified ProductID.
|
|
[dbo].[uspLogError]
|
Oct 14 2005 1:58AM |
Oct 14 2005 1:58AM |
1 |
2,075 |
35 |
3 |
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]
|
Oct 14 2005 1:58AM |
Oct 14 2005 1:58AM |
0 |
729 |
32 |
1 |
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.
|
|
[HumanResources].[uspUpdateEmployeeHireInfo]
|
Oct 14 2005 2:00AM |
Oct 14 2005 2:00AM |
7 |
1,144 |
0 |
5 |
Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.
|
|
[HumanResources].[uspUpdateEmployeeLogin]
|
Oct 14 2005 2:00AM |
Oct 14 2005 2:00AM |
6 |
667 |
0 |
4 |
Updates the Employee table with the values specified in the input parameters for the given EmployeeID.
|
|
[HumanResources].[uspUpdateEmployeePersonalInfo]
|
Oct 14 2005 2:00AM |
Oct 14 2005 2:00AM |
5 |
646 |
0 |
3 |
Updates the Employee table with the values specified in the input parameters for the given EmployeeID.
|
