Generated using SQL Data Dictionary demo version.


Procedure HumanResources.uspUpdateEmployeeHireInfo


Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.


Parameter Data Type Default Is Output
@BusinessEntityID int
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid BusinessEntityID from the Employee table.
@JobTitle nvarchar(50)
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a title for the employee.
@HireDate datetime
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a hire date for the employee.
@RateChangeDate datetime
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the date the rate changed for the employee.
@Rate money
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the new rate for the employee.
@PayFrequency tinyint
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the pay frequency for the employee.
@CurrentFlag Flag(bit)
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee.

Uses: