改成before触发器

1楼: CREATE trigger mytrigger on t_user for delete as delete t_qxb from deleted where t_qxb.yhm=deleted.yhm 各位老师，麻烦了，帮我改成before触发器！！ 字串5

2楼: 不能沉啊 字串5

3楼: 虽没吃饭，我还是要顶~ 字串2

4楼: 如果你是用sqlserver数据库，你的触发器就是before触发器。 字串5

5楼: 吃饭和顶有必然的联系吗？[^][^] 字串7

6楼: To..TYZhang 不是吧，我的主从表有关联，触发受限，必须先删除从表，再删主表。 无关联就不用考虑了。 字串4

7楼: TYZhang说的对，可怎么解决我上面的问题呢 字串2

8楼: CREATE trigger mytrigger on t_user instead of delete as begin delete t_qxb from deleted where t_qxb.yhm=deleted.yhm delete t_user from deleted where t_user.yhm=deleted.yhm end

字串8

9楼: 多人接受答案了。

字串2