34,594
社区成员
发帖
与我相关
我的任务
分享这样建立触发器有什么错误??怎么总语法错呢?
create trigger tr1
on j
after delete
as
delete from spj,deleted d
where spj.jno=d.jno
按理说因该有这个deleted表吧??
on j
after delete
as
delete from spj,deleted d
where spj.jno=d.jno
按理说因该有这个deleted表吧??
...全文
请发表友善的回复…
发表回复
dangxuehua 2003-05-21
- 打赏
- 举报
create trigger tr1
on j
after delete
as
delete from spj where jno in (select jno from deleted)
on j
after delete
as
delete from spj where jno in (select jno from deleted)
joygxd 2003-05-21
- 打赏
- 举报
应该可以的呀
愉快的登山者 2003-05-21
- 打赏
- 举报
create trigger tr1
on j
after delete
as
delete spj from deleted d
where spj.jno=d.jno
on j
after delete
as
delete spj from deleted d
where spj.jno=d.jno
