Difference between revisions of "HumanResources.uspUpdateEmployeeHireInfo (procedure)"
Line 52: | Line 52: | ||
END; | END; | ||
</pre> | </pre> | ||
− | |||
== automatically generated == | == automatically generated == | ||
Line 59: | Line 58: | ||
| '''procedure | | '''procedure | ||
| HumanResources.uspUpdateEmployeeHireInfo | | HumanResources.uspUpdateEmployeeHireInfo | ||
− | |- | + | |- valign="top" |
| '''Description | | '''Description | ||
Line 119: | Line 118: | ||
| '''Object Type | | '''Object Type | ||
| '''Dependency Type | | '''Dependency Type | ||
− | + | ||
|- | |- | ||
| [[HumanResources.Employee_(table)|HumanResources.Employee]] | | [[HumanResources.Employee_(table)|HumanResources.Employee]] | ||
Line 132: | Line 131: | ||
| Procedure | | Procedure | ||
| Execute | | Execute | ||
+ | |- | ||
+ | | [[.HumanResources_(schema)|.HumanResources]] | ||
+ | | Schema | ||
+ | | Schema | ||
|} | |} |
Revision as of 07:25, 30 November 2009
wikibot
procedure | HumanResources.uspUpdateEmployeeHireInfo |
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;
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;
Referenced Object | Object Type | Dependency Type |
HumanResources.Employee | Table | Update |
HumanResources.EmployeePayHistory | Table | Insert |
dbo.uspLogError | Procedure | Execute |
.HumanResources | Schema | Schema |