解决方案: |
新建一触发器解决。代码如下:CREATE TRIGGER tCDLCODE ON [dbo].[DispatchList]
FOR UPDATE
AS
declare @tCode as varchar(10)
declare @tcCode as varchar(10)
if (select cdlcode from inserted)<>(select cdlcode from deleted)
begin
update a set a.cdlcode =b.cdlcode from DispatchList a, (select cdlcode from deleted) b where a.cdlcode in (select cdlcode from inserted)
select @tCode=substring(cdlcode,2,1) from inserted
select @tccode=substring(cdlcode,3,6) from inserted
update voucherhistory set cNumber=convert(int,@tccode)-1 Where CardNumber='01' and cContent='部门' and cSeed=@tCode
end |