Databases
>
AdventureWorks2019
>
Stored Procedures
> HumanResources.uspUpdateEmployeeHireInfo
AdventureWorks2019
HumanResources.uspUpdateEmployeeHireInfo
//
Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.
Created:
5/8/2023
Modified:
5/8/2023
Parameters
//
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid BusinessEntityID from the Employee table.
@BusinessEntityID
[int] NULL
//
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a title for the employee.
@JobTitle
[nvarchar](50) NULL
//
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a hire date for the employee.
@HireDate
[datetime] NULL
//
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the date the rate changed for the employee.
@RateChangeDate
[datetime] NULL
//
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the new rate for the employee.
@Rate
[money] NULL
//
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the pay frequency for the employee.
@PayFrequency
[tinyint] NULL
//
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee.
@CurrentFlag
[Flag] NULL
Definition