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

Update Trigger to Increment a Version Number Column

database

SQL