UC知道触发器错误！！！！
来源：百度知道 编辑：UC知道 时间：2024/06/28 00:36:59
CREATE trigger delForBoard
on tb_board
for delete
as
begin
delete from tb_html from tb_html h,tb_board b where h.zt_groupid=b.zt_id
end
然后我执行
delete from tb_board where zt_id=17
发现tb_html表里的数据全没了！！！！
on tb_board
for delete
as
begin
delete from tb_html from tb_html h,tb_board b where h.zt_groupid=b.zt_id
end
然后我执行
delete from tb_board where zt_id=17
发现tb_html表里的数据全没了！！！！
当然咯，你应该根据 DELETED 表来删除数据，而不是直接根据
tb_board 表做关联。
建议你先去看一下联机丛书 DELETED 表
CREATE trigger delForBoard
on tb_board
for delete
as
begin
delete from tb_html from tb_html h,deleted b where h.zt_groupid=b.zt_id
end