create trigger triname on a for delete as delete b where b.ddd=delete.sss
对不起上面的delete少了d,应该为deleted
create trigger triname on a as if exists (select * from a where sss in (select ddd from b)) begin delete b where b.ddd = deleted.sss end
USE youdatabase IF EXISTS (SELECT name FROM sysobjects WHERE name = 'trigername' AND type = 'TR') DROP TRIGGER trigername GO CREATE TRIGGER trigername ON a FOR delete AS delete from b where b.ddd=deleted.sss GO
for delete
as
delete b
where b.ddd=delete.sss
as
if exists (select * from a where sss in (select ddd from b))
begin
delete b where b.ddd = deleted.sss
end
IF EXISTS (SELECT name FROM sysobjects
WHERE name = 'trigername' AND type = 'TR')
DROP TRIGGER trigername
GO
CREATE TRIGGER trigername
ON a
FOR delete
AS
delete from b
where b.ddd=deleted.sss
GO
还有我们现在安装的Norton好象不是域用户的话,就不能自动更新病毒库。