alter trigger Tri_UpdateMjbjMf
on bjmshelfmj
after Delete
as
if(select count(*) from bjmshelfmj,deleted as d where
bjmshelfmj.mjbj_id=d.mjbj_id and
bjmshelfmj.mshelf_id=d.mshelf_id )=0
BEGIN
delete from bjmshelf,Deleted where bjmsshelf_test1=1 and --报错 ??什么原因呢?
bjmshelf.mjbj_id=deleted.mjbj_id and bjmshelf.mshelf_id=deleted.mshelf_id
END
各位高手看看 什么原因啊?
on bjmshelfmj
after Delete
as
if(select count(*) from bjmshelfmj,deleted as d where
bjmshelfmj.mjbj_id=d.mjbj_id and
bjmshelfmj.mshelf_id=d.mshelf_id )=0
BEGIN
delete from bjmshelf,Deleted where bjmsshelf_test1=1 and --报错 ??什么原因呢?
bjmshelf.mjbj_id=deleted.mjbj_id and bjmshelf.mshelf_id=deleted.mshelf_id
END
各位高手看看 什么原因啊?
bjmshelf.mjbj_id=deleted.mjbj_id and bjmshelf.mshelf_id=deleted.mshelf_id
delete a from bjmshelf a,Deleted b where a.bjmsshelf_test1=1 and --报错 ??什么原因呢?
a.mjbj_id=b.mjbj_id and a.mshelf_id=b.mshelf_id
bjmshelf.mjbj_id=deleted.mjbj_id and bjmshelf.mshelf_id=deleted.mshelf_id
from bjmshelf b , Deleted d where b.bjmsshelf_test1=1 and
b.mjbj_id=d.mjbj_id and b.mshelf_id=d.mshelf_id