CREATE TRIGGER [TRIGGER NAME] ON [dbo].[表1] FOR DELETE AS delete 表2 from 表2 a inner join deleted b on a.id=b.id
delete 表2 where id in (select id 表1 where id = deleted.id)
create trigger del on userinferno instead of delete as delete from inferno where uid in (select uid from deleted)delete from userinferno 这样之后 inferno表中的数据 是没了 但 userinferno 中的数据怎么 删不掉呀 ????
用after或者for触发器:create trigger del on userinferno for delete as delete from inferno where uid in (select uid from deleted)
FOR DELETE
AS
delete 表2 from 表2 a
inner join deleted b on a.id=b.id
on userinferno instead of delete
as
delete from inferno where uid in (select uid from deleted)delete from userinferno
这样之后 inferno表中的数据 是没了 但 userinferno 中的数据怎么 删不掉呀 ????
on userinferno
for delete
as
delete from inferno where uid in (select uid from deleted)