CREATE TRIGGER test ON AdminGroup FOR UPDATE
AS
update C set parent_id = replace(C.parent_id,D.id,'')
from 表child C,deleted D
where charindex(','+cast(C.id as varchar(10))+',',','+D.child_id+',')>0
update C set parent_id = C.parent_id+I.id
from 表child C,inserted I
where charindex(','+cast(C.id as varchar(10))+',',','+I.child_id+',')>0