ScrewTurn Wiki
Navigation
Main Page
Random Page
Create a new Page
All Pages
Categories
Administration
File Management
Login/Logout
Language Selection
Your Profile
Create Account
Quick Search
Advanced Search »
Back
History
HumanResources.uspUpdateEmployeePersonalInfo_(procedure)
== wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- valign="top" | '''Procedure''' | HumanResources.uspUpdateEmployeePersonalInfo |- valign="top" | '''Description''' | Updates the Employee table with the values specified in the input parameters for the given EmployeeID. |} === Source === {{{{<nowiki> CREATE PROCEDURE [HumanResources].[uspUpdateEmployeePersonalInfo] @EmployeeID [int], @NationalIDNumber [nvarchar](15), @BirthDate [datetime], @MaritalStatus [nchar](1), @Gender [nchar](1) WITH EXECUTE AS CALLER AS BEGIN SET NOCOUNT ON; BEGIN TRY UPDATE [HumanResources].[Employee] SET [NationalIDNumber] = @NationalIDNumber ,[BirthDate] = @BirthDate ,[MaritalStatus] = @MaritalStatus ,[Gender] = @Gender WHERE [EmployeeID] = @EmployeeID; END TRY BEGIN CATCH EXECUTE [dbo].[uspLogError]; END CATCH; END; </nowiki>}}}} === 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" |- | '''procedure''' | HumanResources.uspUpdateEmployeePersonalInfo |- valign="top" | '''Description''' | Updates the Employee table with the values specified in the input parameters for the given EmployeeID. |- |} {{{{<nowiki> CREATE PROCEDURE [HumanResources].[uspUpdateEmployeePersonalInfo] @EmployeeID [int], @NationalIDNumber [nvarchar](15), @BirthDate [datetime], @MaritalStatus [nchar](1), @Gender [nchar](1) WITH EXECUTE AS CALLER AS BEGIN SET NOCOUNT ON; BEGIN TRY UPDATE [HumanResources].[Employee] SET [NationalIDNumber] = @NationalIDNumber ,[BirthDate] = @BirthDate ,[MaritalStatus] = @MaritalStatus ,[Gender] = @Gender WHERE [EmployeeID] = @EmployeeID; END TRY BEGIN CATCH EXECUTE [dbo].[uspLogError]; END CATCH; END; </nowiki>}}}} {| 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]] |}
ScrewTurn Wiki version 2.0.36. Some of the icons created by
FamFamFam
.