HumanResources.uspUpdateEmployeeLogin Stored Procedure

Description

Updates the Employee table with the values specified in the input parameters for the given EmployeeID.

Properties

Creation Date	08/01/2010 08:41
Encrypted
Ansi Nulls

Parameters

Parameter	Direction	Description	Data Type	Size
@EmployeeID	In	Input parameter for the stored procedure uspUpdateEmployeeLogin. Enter a valid EmployeeID from the Employee table.	int	4
@ManagerID	In	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid ManagerID for the employee.	int	4
@LoginID	In	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid login for the employee.	nvarchar	256
@Title	In	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a title for the employee.	nvarchar	50
@HireDate	In	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a hire date for the employee.	datetime	4
@CurrentFlag	In	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee.	dbo.Flag	1
@RETURN_VALUE	Return Value		int	4

Objects that HumanResources.uspUpdateEmployeeLogin depends on

Database Object	Object Type	Description	Dep Level
Person.Contact	Table	Names of each employee, customer contact, and vendor contact.	2
HumanResources.Employee	Table	Employee information such as salary, department, and title.	1
dbo.ErrorLog	Table	Audit table tracking errors in the the AdventureWorks database that are caught by the CATCH block of a TRY...CATCH construct. Data is inserted by stored procedure dbo.uspLogError when it is executed from inside the CATCH block of a TRY...CATCH construct.	2
dbo.Flag	User Defined Data Type		1
dbo.Name	User Defined Data Type		3
dbo.NameStyle	User Defined Data Type		3
dbo.Phone	User Defined Data Type		3
dbo.uspLogError	Stored Procedure	Logs error information in the ErrorLog table about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without inserting error information.	1
dbo.uspPrintError	Stored Procedure	Prints error information about the error that caused execution to jump to the CATCH block of a TRY...CATCH construct. Should be executed from within the scope of a CATCH block otherwise it will return without printing any error information.	2

Procedure Source Code

CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeLogin]
@EmployeeID [int], 
@ManagerID [int],
@LoginID [nvarchar](256),
@Title [nvarchar](50),
@HireDate [datetime],
@CurrentFlag [dbo].[Flag]
WITH EXECUTE AS CALLER
AS

BEGIN
SET NOCOUNT ON;
BEGIN TRY
UPDATE [HumanResources].[Employee] 
SET [ManagerID] = @ManagerID 
,[LoginID] = @LoginID 
,[Title] = @Title 
,[HireDate] = @HireDate 
,[CurrentFlag] = @CurrentFlag 
WHERE [EmployeeID] = @EmployeeID;
END TRY
BEGIN CATCH
EXECUTE [dbo].[uspLogError];
END CATCH;
END;

Related Objects