Change style:

Big /
Small

Posted By

rengber on 08/07/07

Tagged

database tsql trigger Technique

Versions (?)

Update Trigger to Increment a Version Number Column

/ Published in: SQL

Expand | Embed | Plain Text

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

Report this snippet Tweet

Comment:

You need to login to post a comment.