Generated using SQL Data Dictionary demo version.


Procedure HumanResources.uspUpdateEmployeePersonalInfo


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


Parameter Data Type Default Is Output
@BusinessEntityID int
Input parameter for the stored procedure uspUpdateEmployeePersonalInfo. Enter a valid BusinessEntityID from the HumanResources.Employee table.
@NationalIDNumber nvarchar(15)
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a national ID for the employee.
@BirthDate datetime
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a birth date for the employee.
@MaritalStatus nchar(1)
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a marital status for the employee.
@Gender nchar(1)
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a gender for the employee.

Uses: