HumanResources.uspUpdateEmployeePersonalInfo

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	HumanResources
Name	uspUpdateEmployeePersonalInfo
Module	Human Resources

Input/Output

	Mode	Name	Data type	Description
1	IN	BusinessEntityID	int	Input parameter for the stored procedure uspUpdateEmployeePersonalInfo. Enter a valid BusinessEntityID from the HumanResources.Employee table.
Input parameter for the stored procedure uspUpdateEmployeePersonalInfo. Enter a valid BusinessEntityID from the HumanResources.Employee table.
2	IN	NationalIDNumber	nvarchar(15)	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a national ID for the employee.
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a national ID for the employee.
3	IN	BirthDate	datetime	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a birth date for the employee.
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a birth date for the employee.
4	IN	MaritalStatus	nchar(1)	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a marital status for the employee.
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a marital status for the employee.
5	IN	Gender	nchar(1)	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a gender for the employee.
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a gender for the employee.

Uses

Name
HumanResources.uspUpdateEmployeePersonalInfo
HumanResources.Employee
HumanResources.Employee
dbo.uspLogError
dbo.ErrorLog
dbo.uspPrintError

Script

CREATE PROCEDURE [HumanResources].[uspUpdateEmployeePersonalInfo] @BusinessEntityID [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 [BusinessEntityID] = @BusinessEntityID; END TRY BEGIN CATCH EXECUTE [uspLogError]; END CATCH; END;

CREATE PROCEDURE [HumanResources].[uspUpdateEmployeePersonalInfo]
    @BusinessEntityID [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 [BusinessEntityID] = @BusinessEntityID;
    END TRY
    BEGIN CATCH
        EXECUTE [uspLogError];
    END CATCH;
END;

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56