create trigger tri_a_ins
on a
for delete
as
declare @a int
set @a=( select box from b where goodsid in (select goodsid from inserted))
if (@a!=0)
delete a where goodsid=2
on a
for delete
as
declare @a int
set @a=( select box from b where goodsid in (select goodsid from inserted))
if (@a!=0)
delete a where goodsid=2
on a
for delete
as
declare @a int
set @a=( select box from b where goodsid in (select goodsid from inserted))
if (@a!=0)
delete a from deleted d where goodsid=2 and d.type=a.type
for delete
as
if (select b.box from b,deleted c where b.goodsid=c.googsid)<>0
delete a from deleted d where a.type=d.type and a.goodsid=2