Stored procedures | SQL 2005 Adventure Works OLTP |
Updates the Employee table with the values specified in the input parameters for the given EmployeeID.
Syntax
HumanResources.uspUpdateEmployeePersonalInfo ( EmployeeID, NationalIDNumber, BirthDate, MaritalStatus, Gender )
Parameters
Variable Data Type Required Output Description EmployeeID int Yes No Input parameter for the stored procedure uspUpdateEmployeePersonalInfo. Enter a valid EmployeeID from the HumanResources.Employee table. NationalIDNumber nvarchar(15) Yes No Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a national ID for the employee. BirthDate datetime Yes No Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a birth date for the employee. MaritalStatus nchar(1) Yes No Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a marital status for the employee. Gender nchar(1) Yes No Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a gender for the employee.
Properties
Modifies data Transactional Uses cursors Executes procedures Dynamic content Encrypted Yes Yes No No No No
Data Source Activity
Modifications Description HumanResources.Employee Employee information such as salary, department, and title.
Applies to
Stored procedures | Modifies data | Transactional