HumanResources.uDepartment Trigger

Information

Name	HumanResources.uDepartment
Table Name	HumanResources.Department
Created	14.10.2005 1:59:51
Modified	14.10.2005 1:59:51
Disabled
For replication
Instead of trigger
Activates on	UPDATE

SQL Script

CREATE TRIGGER [HumanResources].[uDepartment] ON [HumanResources].[Department] 
AFTER UPDATE NOT FOR REPLICATION AS 
BEGIN
    SET NOCOUNT ON;

    UPDATE [HumanResources].[Department]
    SET [HumanResources].[Department].[ModifiedDate] = GETDATE()
    FROM inserted
    WHERE inserted.[DepartmentID] = [HumanResources].[Department].[DepartmentID];
END;