TR_EmailList_Subscription_Update

CREATE TRIGGER TR_EmailList_Subscription_Update on dbo.EmailList_Subscription 
    FOR UPDATE
    AS
    begin
    set nocount on
    update EmailList_Subscription set UpdateDate = getutcdate()
    where id in (select id from inserted)
    end