Difference between revisions of "HumanResources.uspUpdateEmployeeLogin (procedure)"

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''procedure | HumanResources.uspUpdateEmployeeLogin |- |} <pre> CREATE PROCEDURE [Human...)
 
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
== wikibot ==
 
== wikibot ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- valign="top"
 +
| '''Procedure
 +
| HumanResources.uspUpdateEmployeeLogin
 +
|- valign="top"
 +
| '''Description
 +
| Updates the Employee table with the values specified in the input parameters for the given EmployeeID.
 +
|}
 +
 +
=== Source ===
 +
<pre>
 +
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;
 +
</pre>
 +
 +
=== References ===
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|- valign="top"
 +
| Update
 +
| Table
 +
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 +
 +
|- valign="top"
 +
| Execute
 +
| Procedure
 +
| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 +
 +
|- valign="top"
 +
| Schema
 +
| Schema
 +
| [[HumanResources_(schema)|HumanResources]]
 +
 +
|}
 +
 +
 +
== automatically generated ==
  
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
Line 5: Line 70:
 
| '''procedure
 
| '''procedure
 
| HumanResources.uspUpdateEmployeeLogin
 
| HumanResources.uspUpdateEmployeeLogin
 +
|- valign="top"
 +
| '''Description
 +
| Updates the Employee table with the values specified in the input parameters for the given EmployeeID.
 
|-
 
|-
 
|}
 
|}
  
 
<pre>
 
<pre>
 +
 
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeLogin]
 
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeLogin]
 
     @EmployeeID [int],  
 
     @EmployeeID [int],  
Line 35: Line 104:
 
END;
 
END;
 
</pre>
 
</pre>
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Dependency Type
 +
| '''Object Type
 +
| '''Referenced Object
 +
 +
|-
 +
| Update
 +
| Table
 +
| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 +
 +
|-
 +
| Execute
 +
| Procedure
 +
| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 +
 +
|-
 +
| Schema
 +
| Schema
 +
| [[HumanResources_(schema)|HumanResources]]
 +
 +
|}

Latest revision as of 23:16, 23 June 2010

wikibot[edit]

Procedure HumanResources.uspUpdateEmployeeLogin
Description Updates the Employee table with the values specified in the input parameters for the given EmployeeID.

Source[edit]

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;

References[edit]

Dependency Type Object Type Referenced Object
Update Table HumanResources.Employee
Execute Procedure dbo.uspLogError
Schema Schema HumanResources


automatically generated[edit]

procedure HumanResources.uspUpdateEmployeeLogin
Description Updates the Employee table with the values specified in the input parameters for the given EmployeeID. 

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;


Dependency Type Object Type Referenced Object
Update Table HumanResources.Employee
Execute Procedure dbo.uspLogError
Schema Schema HumanResources
Retrieved from "http://dbshelp.devio.at/index.php?title=HumanResources.uspUpdateEmployeeLogin_(procedure)&oldid=2604"