Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- IF OBJECT_ID('SomeSchema.tableName', 'U') IS NOT NULL
- BEGIN
- CREATE TRIGGER [schema].[triggername]
- ON [schema].[tableName]
- FOR UPDATE
- AS
- BEGIN
- IF @@ROWCOUNT = 0 RETURN
- SET NOCOUNT ON
- UPDATE SomeSchema.SomeTable
- SET SomeColumn = GETUTCDATE(),
- OtherColumn = HOST_NAME()
- FROM SomeSchema.SomeTable INNER JOIN INSERTED ON INSERTED.ID =
- SomeSchema.SomeTable.Id
- END
- END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement