Difference between revisions of "HumanResources.uspUpdateEmployeeHireInfo (procedure)"
Line 5: | Line 5: | ||
| '''procedure | | '''procedure | ||
| HumanResources.uspUpdateEmployeeHireInfo | | HumanResources.uspUpdateEmployeeHireInfo | ||
+ | |- valign="top" | ||
+ | | '''Description | ||
+ | | Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. | ||
|- | |- | ||
|} | |} | ||
Line 52: | Line 55: | ||
END; | END; | ||
</pre> | </pre> | ||
+ | |||
+ | |||
+ | {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" | ||
+ | |- style="background:silver" | ||
+ | | '''Dependency Type | ||
+ | | '''Object Type | ||
+ | | '''Referenced Object | ||
+ | |||
+ | |- | ||
+ | | Update | ||
+ | | Table | ||
+ | | [[HumanResources.Employee_(table)|HumanResources.Employee]] | ||
+ | |||
+ | |- | ||
+ | | Insert | ||
+ | | Table | ||
+ | | [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]] | ||
+ | |||
+ | |- | ||
+ | | Execute | ||
+ | | Procedure | ||
+ | | [[dbo.uspLogError_(procedure)|dbo.uspLogError]] | ||
+ | |||
+ | |} | ||
+ | |||
+ | |||
+ | |||
== automatically generated == | == automatically generated == | ||
Revision as of 22:56, 28 December 2009
wikibot
procedure | HumanResources.uspUpdateEmployeeHireInfo |
Description | Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. |
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeHireInfo] @EmployeeID [int], @Title [nvarchar](50), @HireDate [datetime], @RateChangeDate [datetime], @Rate [money], @PayFrequency [tinyint], @CurrentFlag [dbo].[Flag] WITH EXECUTE AS CALLER AS BEGIN SET NOCOUNT ON; BEGIN TRY BEGIN TRANSACTION; UPDATE [HumanResources].[Employee] SET [Title] = @Title ,[HireDate] = @HireDate ,[CurrentFlag] = @CurrentFlag WHERE [EmployeeID] = @EmployeeID; INSERT INTO [HumanResources].[EmployeePayHistory] ([EmployeeID] ,[RateChangeDate] ,[Rate] ,[PayFrequency]) VALUES (@EmployeeID, @RateChangeDate, @Rate, @PayFrequency); COMMIT TRANSACTION; END TRY BEGIN CATCH -- Rollback any active or uncommittable transactions before -- inserting information in the ErrorLog IF @@TRANCOUNT > 0 BEGIN ROLLBACK TRANSACTION; END EXECUTE [dbo].[uspLogError]; END CATCH; END;
Dependency Type | Object Type | Referenced Object |
Update | Table | HumanResources.Employee |
Insert | Table | HumanResources.EmployeePayHistory |
Execute | Procedure | dbo.uspLogError |
automatically generated
procedure | HumanResources.uspUpdateEmployeeHireInfo |
Description | Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters. |
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeHireInfo] @EmployeeID [int], @Title [nvarchar](50), @HireDate [datetime], @RateChangeDate [datetime], @Rate [money], @PayFrequency [tinyint], @CurrentFlag [dbo].[Flag] WITH EXECUTE AS CALLER AS BEGIN SET NOCOUNT ON; BEGIN TRY BEGIN TRANSACTION; UPDATE [HumanResources].[Employee] SET [Title] = @Title ,[HireDate] = @HireDate ,[CurrentFlag] = @CurrentFlag WHERE [EmployeeID] = @EmployeeID; INSERT INTO [HumanResources].[EmployeePayHistory] ([EmployeeID] ,[RateChangeDate] ,[Rate] ,[PayFrequency]) VALUES (@EmployeeID, @RateChangeDate, @Rate, @PayFrequency); COMMIT TRANSACTION; END TRY BEGIN CATCH -- Rollback any active or uncommittable transactions before -- inserting information in the ErrorLog IF @@TRANCOUNT > 0 BEGIN ROLLBACK TRANSACTION; END EXECUTE [dbo].[uspLogError]; END CATCH; END;
Dependency Type | Object Type | Referenced Object |
Update | Table | HumanResources.Employee |
Insert | Table | HumanResources.EmployeePayHistory |
Execute | Procedure | dbo.uspLogError |
Schema | Schema | HumanResources |