www.pudn.com > cygl.rar > tr_czr.sql

--用于删除某个帐户时,相应的删除该帐户的操作记录 
create trigger tr_czr on [dbo].[Czr] 
For delete 
As 
declare @czrname varchar(50) 
--选出被删除的账号 
select @czrname=czrname 
from deleted 
--删除Czjl表中属于该帐户的操作记录 
delete from czjl 
where czrname=@czrname;