关于触发器 CREATE TRIGGER t1 ON company for delete

[江鸟的坚持]

现一公司表compay，产品表product,供求表supply
company(cid,cname)
product(pid,pname)
supply(sid,sname)
我想实现当删除公司表里的一条记录时，用触发器删除属于此公司的产品，供求信息。
请高手帮忙！

[xeqtr1982]

create trigger cfq on company
for delete
as

if @@rowcount=0 return

delete product from deleted a,product b where a.cid=b.pid
delete supply from deleted a,supply b where a.cid=b.sid
go

??

[itblog]

好快啊~是不是以每秒二百次的刷新速度

[xeqtr1982]

每秒200次？手指头断了

[xeqtr1982]

:)

[江鸟的坚持]

谢了，哈哈！

[lanyigoo]

本人认为product 和supply还要加一个外键：cid
create trigger tr_company on company after delete
as


begin
delete product from deleted a,product b where a.cid=b.cid
delete supply from deleted a,supply b where a.cid=b.cid
end