ALTER trigger tri_ar_Gathering_Update on t_ar_Gathering for Update
as
/**************************************************************
Func:
销售收款,作为预先核销
**************************************************************/
begin
declare @Code varchar(20),
@PreReceiveMoney money if update(PreReceiveMoney) begin
select @PreReceiveMoney=PreReceiveMoney from inserted
--
if(@PreReceiveMoney>0)begin
exec p_getBillCode 'YS',@Code out insert into t_ar_PreReceive(PreReceiveCode,CustomerID,GatheringCode,PreReceiveMoney,PreReceiveDt)
select @Code,CustomerID,GatheringCode,PreReceiveMoney,VerifyDt from inserted
end
--
else begin
delete from t_ar_PreReceive where GatheringCode in(select GatheringCode from inserted)
end
if(@@error<>0)begin
rollback
return
end
end
end
as
/**************************************************************
Func:
销售收款,作为预先核销
**************************************************************/
begin
declare @Code varchar(20),
@PreReceiveMoney money if update(PreReceiveMoney) begin
select @PreReceiveMoney=PreReceiveMoney from inserted
--
if(@PreReceiveMoney>0)begin
exec p_getBillCode 'YS',@Code out insert into t_ar_PreReceive(PreReceiveCode,CustomerID,GatheringCode,PreReceiveMoney,PreReceiveDt)
select @Code,CustomerID,GatheringCode,PreReceiveMoney,VerifyDt from inserted
end
--
else begin
delete from t_ar_PreReceive where GatheringCode in(select GatheringCode from inserted)
end
if(@@error<>0)begin
rollback
return
end
end
end
执行
alter table 表名 enable trigger
试试触发器会否恢复,如果不行,应该是触发器代码有问题。