TR_APPUSERCLAIMS_EMAILUPDATED

            create trigger dbo.TR_APPUSERCLAIMS_EMAILUPDATED on dbo.APPUSERCLAIMS after update not for replication
            as
            begin
                if update(EMAILADDRESS) begin
                    delete from dbo.APPUSERCLAIMS from INSERTED ins left join DELETED del on ins.APPUSERID = del.APPUSERID where APPUSERCLAIMS.APPUSERID = ins.APPUSERID and del.EMAILADDRESS <> ins.EMAILADDRESS;
                end
            end