qry_qj.Delete;这个是就一句的删除代码!! 触发器里的是 CREATE TRIGGER old_sys_qj_del ON [dbo].[Table_qj] after DELETE AS DELETE kt_lrskq FROM kt_lrskq inner join deleted on (user_serial =user_id) AND (kssj =[date] )
把触发器改一下 CREATE TRIGGER old_sys_qj_del ON [dbo].[Table_qj] after DELETE AS 加上下面这句话 SET NOCOUNT ONDELETE kt_lrskq FROM kt_lrskq inner join deleted on (user_serial =user_id) AND (kssj =[date] )
触发器里的是
CREATE TRIGGER old_sys_qj_del ON [dbo].[Table_qj]
after DELETE
AS
DELETE kt_lrskq FROM kt_lrskq
inner join deleted on (user_serial =user_id) AND (kssj =[date] )
CREATE TRIGGER old_sys_qj_del ON [dbo].[Table_qj]
after DELETE
AS
加上下面这句话
SET NOCOUNT ONDELETE kt_lrskq FROM kt_lrskq
inner join deleted on (user_serial =user_id) AND (kssj =[date] )