Difference between revisions of "HumanResources.uspUpdateEmployeeHireInfo (procedure)"

From dbscript Online Help
Jump to: navigation, search
 
(2 intermediate revisions by the same user not shown)
Line 2: Line 2:
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
+
|- valign="top"
| '''procedure
+
| '''Procedure
 
| HumanResources.uspUpdateEmployeeHireInfo
 
| HumanResources.uspUpdateEmployeeHireInfo
 
|- valign="top"
 
|- valign="top"
 
| '''Description
 
| '''Description
 
| Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.
 
| Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.
|-
 
 
|}
 
|}
  
 +
=== Source ===
 
<pre>
 
<pre>
 
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeHireInfo]
 
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeHireInfo]
Line 56: Line 56:
 
</pre>
 
</pre>
  
 
+
=== References ===
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
|- style="background:silver"
 
|- style="background:silver"
Line 63: Line 63:
 
| '''Referenced Object
 
| '''Referenced Object
  
|-
+
|- valign="top"
 
| Update
 
| Update
 
| Table
 
| Table
 
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
  
|-
+
|- valign="top"
 
| Insert
 
| Insert
 
| Table
 
| Table
 
| [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]]
 
| [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]]
  
|-
+
|- valign="top"
 
| Execute
 
| Execute
 
| Procedure
 
| Procedure
 
| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 
| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[HumanResources_(schema)|HumanResources]]
  
 
|}
 
|}
 
  
  

Latest revision as of 23:16, 23 June 2010

wikibot[edit]

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.

Source[edit]

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;

References[edit]

Dependency Type Object Type Referenced Object
Update Table HumanResources.Employee
Insert Table HumanResources.EmployeePayHistory
Execute Procedure dbo.uspLogError
Schema Schema HumanResources


automatically generated[edit]

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