ScrewTurn Wiki

Edit

wikibot

ProcedureHumanResources.uspUpdateEmployeePersonalInfo
DescriptionUpdates the Employee table with the values specified in the input parameters for the given EmployeeID.

Edit

Source

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;

Edit

References

Dependency TypeObject TypeReferenced Object
UpdateTableHumanResources.Employee
ExecuteProceduredbo.uspLogError
SchemaSchemaHumanResources

Edit

automatically generated

procedure HumanResources.uspUpdateEmployeePersonalInfo
DescriptionUpdates the Employee table with the values specified in the input parameters for the given EmployeeID.


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;

Dependency TypeObject TypeReferenced Object
UpdateTableHumanResources.Employee
ExecuteProceduredbo.uspLogError
SchemaSchemaHumanResources

ScrewTurn Wiki version 2.0.36. Some of the icons created by FamFamFam.