HumanResources.uspUpdateEmployeeLogin

AdventureWorks

- AdventureWorks

Documentation	AdventureWorks
Schema	HumanResources
Name	uspUpdateEmployeeLogin
Module	Human Resources

Input/Output

	Mode	Name	Data type	Description
1	IN	BusinessEntityID	int	Input parameter for the stored procedure uspUpdateEmployeeLogin. Enter a valid EmployeeID from the Employee table.
Input parameter for the stored procedure uspUpdateEmployeeLogin. Enter a valid EmployeeID from the Employee table.
2	IN	OrganizationNode	hierarchyid	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid ManagerID for the employee.
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid ManagerID for the employee.
3	IN	LoginID	nvarchar(256)	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid login for the employee.
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a valid login for the employee.
4	IN	JobTitle	nvarchar(50)	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a title for the employee.
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a title for the employee.
5	IN	HireDate	datetime	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a hire date for the employee.
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter a hire date for the employee.
6	IN	CurrentFlag	bit	Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee.
Input parameter for the stored procedure uspUpdateEmployeeHireInfo. Enter the current flag for the employee.

Uses

Name
HumanResources.uspUpdateEmployeeLogin
HumanResources.Employee
HumanResources.Employee
dbo.uspLogError
dbo.ErrorLog
dbo.uspPrintError

Script

CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeLogin] @BusinessEntityID [int], @OrganizationNode [hierarchyid], @LoginID [nvarchar](256), @JobTitle [nvarchar](50), @HireDate [datetime], @CurrentFlag [Flag] WITH EXECUTE AS CALLER AS BEGIN SET NOCOUNT ON; BEGIN TRY UPDATE [HumanResources].[Employee] SET [OrganizationNode] = @OrganizationNode ,[LoginID] = @LoginID ,[JobTitle] = @JobTitle ,[HireDate] = @HireDate ,[CurrentFlag] = @CurrentFlag WHERE [BusinessEntityID] = @BusinessEntityID; END TRY BEGIN CATCH EXECUTE [uspLogError]; END CATCH; END;

CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeLogin]
    @BusinessEntityID [int], 
    @OrganizationNode [hierarchyid],
    @LoginID [nvarchar](256),
    @JobTitle [nvarchar](50),
    @HireDate [datetime],
    @CurrentFlag [Flag]
WITH EXECUTE AS CALLER
AS
BEGIN
    SET NOCOUNT ON;

    BEGIN TRY
        UPDATE [HumanResources].[Employee] 
        SET [OrganizationNode] = @OrganizationNode 
            ,[LoginID] = @LoginID 
            ,[JobTitle] = @JobTitle 
            ,[HireDate] = @HireDate 
            ,[CurrentFlag] = @CurrentFlag 
        WHERE [BusinessEntityID] = @BusinessEntityID;
    END TRY
    BEGIN CATCH
        EXECUTE [uspLogError];
    END CATCH;
END;

Exported: 2019-02-04 23:13, Last imported: 2018-03-07 11:56