CREATE TRIGGER trInsert ON dbo.Products
FOR INSERT
AS
Update
Products
Set
LastUpdate = GetDate()
From
Products p Inner Join Inserted i On p.ProductID = i.ProductID
Where
p.ProductID = i.ProductID
GO
CREATE TRIGGER trUpdate ON dbo.Products
FOR UPDATE
AS
Update
Products
Set
LastUpdate = GetDate()
From
Products p Inner Join Inserted i On p.ProductID = i.ProductID
Where
p.ProductID = i.ProductID
GO