HumanResources.uspUpdateEmployeeHireInfo (procedure) - Revision history

Bot at 22:16, 23 June 2010

2010-06-23T22:16:00Z

Bot at 22:00, 23 June 2010

2010-06-23T22:00:11Z

Bot at 22:07, 2 February 2010

2010-02-02T22:07:23Z

Bot at 21:56, 28 December 2009

2009-12-28T21:56:49Z

Bot at 06:01, 30 November 2009

2009-11-30T06:01:21Z

Bot at 05:39, 30 November 2009

2009-11-30T05:39:33Z

Bot at 05:25, 30 November 2009

2009-11-30T05:25:59Z

Bot at 23:00, 26 November 2009

2009-11-26T23:00:07Z

Bot: New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''procedure | HumanResources.uspUpdateEmployeeHireInfo |- |}

 CREATE PROCEDURE [Hu...

2009-01-03T12:36:20Z

New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''procedure | HumanResources.uspUpdateEmployeeHireInfo |- |} <pre> CREATE PROCEDURE [Hu...

New page

== wikibot ==

{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
|-
| '''procedure
| HumanResources.uspUpdateEmployeeHireInfo
|-
|}

<pre>
CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeHireInfo]
@EmployeeID [int],
@Title [nvarchar](50),
@HireDate [datetime],
@RateChangeDate [datetime],
@Rate [money],
@PayFrequency [tinyint],
@CurrentFlag [dbo].[Flag]
WITH EXECUTE AS CALLER
AS
BEGIN
SET NOCOUNT ON;

BEGIN TRY
BEGIN TRANSACTION;

UPDATE [HumanResources].[Employee]
SET [Title] = @Title
,[HireDate] = @HireDate
,[CurrentFlag] = @CurrentFlag
WHERE [EmployeeID] = @EmployeeID;

INSERT INTO [HumanResources].[EmployeePayHistory]
([EmployeeID]
,[RateChangeDate]
,[Rate]
,[PayFrequency])
VALUES (@EmployeeID, @RateChangeDate, @Rate, @PayFrequency);

COMMIT TRANSACTION;
END TRY
BEGIN CATCH
-- Rollback any active or uncommittable transactions before
-- inserting information in the ErrorLog
IF @@TRANCOUNT > 0
BEGIN
ROLLBACK TRANSACTION;
END

EXECUTE [dbo].[uspLogError];
END CATCH;
END;
</pre>

@@ Line 66: / Line 66: @@
 | Update
 | Table
-| [[HumanResources.Employee_(_(table))|HumanResources.Employee]]
+| [[HumanResources.Employee_(table)|HumanResources.Employee]]
 |- valign="top"
 | Insert
 | Table
-| [[HumanResources.EmployeePayHistory_(_(table))|HumanResources.EmployeePayHistory]]
+| [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]]
 |- valign="top"
 | Execute
 | Procedure
-| [[dbo.uspLogError_(_(procedure))|dbo.uspLogError]]
+| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 |- valign="top"
 | Schema
 | Schema
-| [[HumanResources_(_(schema))|HumanResources]]
+| [[HumanResources_(schema)|HumanResources]]
 |}

@@ Line 2: / Line 2: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
-|-
+|- valign="top"
 | '''Procedure
 | HumanResources.uspUpdateEmployeeHireInfo
@@ Line 8: / Line 8: @@
 | '''Description
 | Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.
 |}
 === Source ===
@@ Line 65: / Line 63: @@
 | '''Referenced Object
-|-
+|- valign="top"
 | Update
 | Table
-| [[HumanResources.Employee_(table)|HumanResources.Employee]]
+| [[HumanResources.Employee_(_(table))|HumanResources.Employee]]
-|-
+|- valign="top"
 | Insert
 | Table
-| [[HumanResources.EmployeePayHistory_(table)|HumanResources.EmployeePayHistory]]
+| [[HumanResources.EmployeePayHistory_(_(table))|HumanResources.EmployeePayHistory]]
-|-
+|- valign="top"
 | Execute
 | Procedure
-| [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
+| [[dbo.uspLogError_(_(procedure))|dbo.uspLogError]]
-|-
+|- valign="top"
 | Schema
 | Schema
-| [[HumanResources_(schema)|HumanResources]]
+| [[HumanResources_(_(schema))|HumanResources]]
 |}

@@ Line 3: / Line 3: @@
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |-
-| '''procedure
+| '''Procedure
 | HumanResources.uspUpdateEmployeeHireInfo
 |- valign="top"
@@ Line 11: / Line 11: @@
 |}
 <pre>
 CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeHireInfo]
@@ Line 56: / Line 58: @@
 </pre>
+=== References ===
 {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 |- style="background:silver"
@@ Line 77: / Line 79: @@
 | Procedure
 | [[dbo.uspLogError_(procedure)|dbo.uspLogError]]
 |}

@@ Line 5: / Line 5: @@
 | '''procedure
 | HumanResources.uspUpdateEmployeeHireInfo
 |-
 |}
@@ Line 52: / Line 55: @@
 END;
 </pre>
 == automatically generated ==

@@ Line 59: / Line 59: @@
 | HumanResources.uspUpdateEmployeeHireInfo
 |- valign="top"
 | '''Description
 | Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.
 |-
 |}

← Older revision		Revision as of 23:00, 26 November 2009
Line 52:		Line 52:
	END;		END;
	</pre>		</pre>
		+
		+	== automatically generated ==
		+
		+	{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
		+	\|-
		+	\| '''procedure
		+	\| HumanResources.uspUpdateEmployeeHireInfo
		+	\|-
		+
		+	\| '''Description
		+	\| Updates the Employee table and inserts a new row in the EmployeePayHistory table with the values specified in the input parameters.
		+	\|-
		+
		+	\|}
		+
		+	<pre>
		+
		+	CREATE PROCEDURE [HumanResources].[uspUpdateEmployeeHireInfo]
		+	@EmployeeID [int],
		+	@Title [nvarchar](50),
		+	@HireDate [datetime],
		+	@RateChangeDate [datetime],
		+	@Rate [money],
		+	@PayFrequency [tinyint],
		+	@CurrentFlag [dbo].[Flag]
		+	WITH EXECUTE AS CALLER
		+	AS
		+	BEGIN
		+	SET NOCOUNT ON;
		+
		+	BEGIN TRY
		+	BEGIN TRANSACTION;
		+
		+	UPDATE [HumanResources].[Employee]
		+	SET [Title] = @Title
		+	,[HireDate] = @HireDate
		+	,[CurrentFlag] = @CurrentFlag
		+	WHERE [EmployeeID] = @EmployeeID;
		+
		+	INSERT INTO [HumanResources].[EmployeePayHistory]
		+	([EmployeeID]
		+	,[RateChangeDate]
		+	,[Rate]
		+	,[PayFrequency])
		+	VALUES (@EmployeeID, @RateChangeDate, @Rate, @PayFrequency);
		+
		+	COMMIT TRANSACTION;
		+	END TRY
		+	BEGIN CATCH
		+	-- Rollback any active or uncommittable transactions before
		+	-- inserting information in the ErrorLog
		+	IF @@TRANCOUNT > 0
		+	BEGIN
		+	ROLLBACK TRANSACTION;
		+	END
		+
		+	EXECUTE [dbo].[uspLogError];
		+	END CATCH;
		+	END;
		+	</pre>
		+
		+
		+	{\| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
		+	\|- style="background:silver"
		+	\| '''Referenced Object
		+	\| '''Object Type
		+	\| '''Dependency Type
		+
		+	\|-
		+	\| [[HumanResources.Employee_(table)\|HumanResources.Employee]]
		+	\| Table
		+	\| Update
		+	\|-
		+	\| [[HumanResources.EmployeePayHistory_(table)\|HumanResources.EmployeePayHistory]]
		+	\| Table
		+	\| Insert
		+	\|-
		+	\| [[dbo.uspLogError_(procedure)\|dbo.uspLogError]]
		+	\| Procedure
		+	\| Execute
		+	\|}