Databases > AdventureWorks2019 > Stored Procedures > HumanResources.uspUpdateEmployeePersonalInfo

AdventureWorks2019

HumanResources.uspUpdateEmployeePersonalInfo

//

Updates the Employee table with the values specified in the input parameters for the given EmployeeID.

Created: 5/8/2023 Modified: 5/8/2023

Parameters

//

Input parameter for the stored procedure uspUpdateEmployeePersonalInfo. Enter a valid BusinessEntityID from the HumanResources.Employee table.

@BusinessEntityID

[int] NULL
//

Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a national ID for the employee.

@NationalIDNumber

[nvarchar](15) NULL
//

Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a birth date for the employee.

@BirthDate

[datetime] NULL
//

Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a marital status for the employee.

@MaritalStatus

[nchar](1) NULL
//

Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a gender for the employee.

@Gender

[nchar](1) NULL

Definition