TR_SiteContent_INSERT_UPDATE

      CREATE TRIGGER [dbo].[TR_SiteContent_INSERT_UPDATE]
    ON [dbo].[SiteContent]
    FOR INSERT, UPDATE
    AS
    UPDATE sp
    SET sp.[UpdateDate] = i.[UpdateDate]
    FROM [dbo].[SitePages] sp
    INNER JOIN [dbo].[PageContent] pc
    ON sp.[ID] = pc.[SitePagesID]
    INNER JOIN inserted i
    ON pc.[SiteContentID] = i.[ID];