我想用触发器实现级联删除
create trigger product_delete
on product
for delete
as
delete from storage,deleted
where storage.productid=deleted.productid
出现这样的错误:服务器: 消息 170,级别 15,状态 1,过程 product_delete,行 30
第 30 行: ',' 附近有语法错误。
请问该如何解决啊
create trigger product_delete
on product
for delete
as
delete from storage,deleted
where storage.productid=deleted.productid
出现这样的错误:服务器: 消息 170,级别 15,状态 1,过程 product_delete,行 30
第 30 行: ',' 附近有语法错误。
请问该如何解决啊
on product
for delete
as
delete storage from storage,deleted
where storage.productid=deleted.productid
delete 后面要指定一个表。
create trigger product_delete
on product
for delete
as
delete a
from storage a,deleted b
where a.productid=b.productid
where storage.productid=deleted.productid
where storage.productid=deleted.productid