| Stored procedures | SQL 2005 Adventure Works OLTP |
Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.
Syntax
HumanResources.uspUpdateEmployeeHireInfo ( EmployeeID, Title, HireDate, RateChangeDate, Rate, PayFrequency, CurrentFlag )
Parameters
Variable Data Type Required Output Description EmployeeID int Yes No Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid EmployeeID from the Employee table. Title nvarchar(50) Yes No Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a title for the employee. HireDate datetime Yes No Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a hire date for the employee. RateChangeDate datetime Yes No Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the date the rate changed for the employee. Rate money Yes No Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the new rate for the employee. PayFrequency tinyint Yes No Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the pay frequency for the employee. CurrentFlag Flag Yes No Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag 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. HumanResources.EmployeePayHistory Employee pay history.
Applies to
Stored procedures | Modifies data | Transactional