HumanResources uspUpdateEmployeePersonalInfo (procedure)

Modified on 2011/08/27 11:17 by wikibot Categorized as Uncategorized

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- valign="top"
| '''Procedure'''
| HumanResources.uspUpdateEmployeePersonalInfo
|- valign="top"
| '''Description'''
| Updates the Employee table with the values specified in the input parameters for the given EmployeeID.
|}

=== Source ===
{{{{<nowiki>
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeePersonalInfo]
    @EmployeeID [int], 
    @NationalIDNumber [nvarchar](15), 
    @BirthDate [datetime], 
    @MaritalStatus [nchar](1), 
    @Gender [nchar](1)
WITH EXECUTE AS CALLER
AS
BEGIN
    SET NOCOUNT ON;

    BEGIN TRY
        UPDATE [HumanResources].[Employee] 
        SET [NationalIDNumber] = @NationalIDNumber 
            ,[BirthDate] = @BirthDate 
            ,[MaritalStatus] = @MaritalStatus 
            ,[Gender] = @Gender 
        WHERE [EmployeeID] = @EmployeeID;
    END TRY
    BEGIN CATCH
        EXECUTE [dbo].[uspLogError];
    END CATCH;
END;
</nowiki>}}}}

=== References ===
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|- style="background:silver"
| '''Dependency Type'''
| '''Object Type'''
| '''Referenced Object'''

|- valign="top"
| Update
| Table
| [[HumanResources Employee (table)|HumanResources.Employee]]

|- valign="top"
| Execute
| Procedure
| [[dbo uspLogError (procedure)|dbo.uspLogError]]

|- valign="top"
| Schema
| Schema
| [[HumanResources (schema)|HumanResources]]

|}

devio dbscript ScrewTurn Wiki

Navigation¶

HumanResources uspUpdateEmployeePersonalInfo (procedure)