create trigger t on parent for update as if update(child_id) update child --- 具体操作 go
OK,自己会了,贴一下,大家帮忙看看哪里可以改进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,重复问题另行处理
on parent
for update
as
if update(child_id)
update child --- 具体操作
go
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,重复问题另行处理