我写的触发器如下:
CREATE TRIGGER [ClassInforDeleteTrigger] ON dbo.tb_ClassInfor
FOR DELETE
ASDECLARE @tb_ClassInforId VARCHAR(10)
SELECT @tb_ClassInforId = BH FROM deleted--备份班级信息到bak_ClassInfor中
INSERT INTO bak_ClassInfor (BH,BJMC,BJRYCH,JBNY,XZ,BJLX,BZR,BZ) SELECT BH,BJMC,BJRYCH,JBNY,XZ,BJLX,BZRXM,BZXM FROM view_ClassInfor WHERE BH = + @tb_ClassInforId但是当删除tb_ClassInfor中的一条记录后,并没有被分到bak_ClassInfor中
请高手赐教:问题出在何处?如何解决?
CREATE TRIGGER [ClassInforDeleteTrigger] ON dbo.tb_ClassInfor
FOR DELETE
ASDECLARE @tb_ClassInforId VARCHAR(10)
SELECT @tb_ClassInforId = BH FROM deleted--备份班级信息到bak_ClassInfor中
INSERT INTO bak_ClassInfor (BH,BJMC,BJRYCH,JBNY,XZ,BJLX,BZR,BZ) SELECT BH,BJMC,BJRYCH,JBNY,XZ,BJLX,BZRXM,BZXM FROM view_ClassInfor WHERE BH = + @tb_ClassInforId但是当删除tb_ClassInfor中的一条记录后,并没有被分到bak_ClassInfor中
请高手赐教:问题出在何处?如何解决?
最好写法简单些(要备份的东西,部分在view_ClassInfor存在而tb_ClassInfor没有)
直接取deleted表的不行吗?INSERT INTO bak_ClassInfor (BH,BJMC,BJRYCH,JBNY,XZ,BJLX,BZR,BZ) SELECT BH,BJMC,BJRYCH,JBNY,XZ,BJLX,BZRXM,BZXM FROM deleted