Advertisement
Guest User

Untitled

a guest
Jun 28th, 2016
165
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.43 KB | None | 0 0
  1. IF OBJECT_ID('SomeSchema.tableName', 'U') IS NOT NULL
  2. BEGIN
  3. CREATE TRIGGER [schema].[triggername]
  4. ON [schema].[tableName]
  5. FOR UPDATE
  6.  
  7. AS
  8. BEGIN
  9. IF @@ROWCOUNT = 0 RETURN
  10.  
  11. SET NOCOUNT ON
  12.  
  13. UPDATE SomeSchema.SomeTable
  14. SET SomeColumn = GETUTCDATE(),
  15. OtherColumn = HOST_NAME()
  16. FROM SomeSchema.SomeTable INNER JOIN INSERTED ON INSERTED.ID =
  17. SomeSchema.SomeTable.Id
  18. END
  19. END
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement