create trigger MessageUpdate
on bbs_Message
for update
asdelete t
from bbs_Message t
join inserted I on t.MID=I.MID
where t.S_Del=1 and R_Del=1
on bbs_Message
for update
asdelete t
from bbs_Message t
join inserted I on t.MID=I.MID
where t.S_Del=1 and R_Del=1
create trigger MessageUpdate
on bbs_Message
for update as
declare @Sender varchar(16)
set @Sender=(select distinct Sender from inserted)
commit
delete from bbs_Message where Sender=@Sender and S_Del=1 and R_Del=1这样是不是你要的效果?