repo.RepoObject__after_update - TR

type: TR ( trigger ), modify_date: 2021-01-28 20:13:00

RepoObject_guid: 2190291C-9D61-EB11-84DC-A81E8446D5B0

Description

Examples

Entity Diagram

entity-repo.repoobject__after_update

References

Referenced Objects

Object Reference Diagram - 1 1

entity_1_1_objectref-repo.repoobject__after_update

Object Reference Diagram - Referenced - 30 0

entity_30_0_objectref-repo.repoobject__after_update

Object Reference Diagram - Referencing - 0 30

entity_0_30_objectref-repo.repoobject__after_update

sql_modules_definition

repo.RepoObject__after_update - TR script 
CREATE TRIGGER [repo].[RepoObject__after_update] ON repo.RepoObject
AFTER UPDATE
AS
UPDATE a
  SET
      [modify_dt] = GETDATE()
FROM   [repo].[RepoObject] AS [a]
       JOIN
       [inserted] AS [b]
       ON [a].[RepoObject_guid] = [b].[RepoObject_guid]