| 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.uspUpdateEmployeeLogin ( EmployeeID, ManagerID, LoginID, Title, HireDate, CurrentFlag )
Parameters
Variable Data Type Required Output Description EmployeeID int Yes No Input parameter for the stored procedure uspUpdateEmployeeLogin. Enter a valid EmployeeID from the Employee table. ManagerID int Yes No Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid ManagerID for the employee. LoginID nvarchar(256) Yes No Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid login for the employee. 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. 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.
Applies to
Stored procedures | Modifies data | Transactional