snippetsmania.com
Post and share your code snippets

CREATE TRIGGER [RobTestTrigger] ON [dbo].[RobTestTable]
FOR UPDATE
AS
UPDATE t
SET t.Version = t.Version + 1
FROM RobTestTable t
JOIN inserted i on i.Id = t.ID

source