F
flyerer1
Unregistered / Unconfirmed
GUEST, unregistred user!
CREATE trigger Modify
on kqjl
for update
as
DECLARE
@cdcs1 int,
@ztcs1 int,
@cdcs2 int,
@ztcs2 int,
@name varchar(16),
@cdate1 varchar(16),
@cdjl int,
@ztjl int
select @cdcs1=i.cdcs,@ztcs1=i.ztcs,@cdcs2=j.cdcs,@ztcs2=j.ztcs,@cdate1=i.cdate,@name=i.name
from kqjl i , deleted j where i.name=j.name and i.cdate=j.cdate
Update dyjl set cdcs=cdcs+(@cdcs1-@cdcs2) ,ztcs=2 where name=RTrim(@name) and dyID=substring(@cdate1,1,6)
dyid为年月(2006-8),cdate为年月日(2006-8-8), 为什么修改了kqjl中的cdcs一个值,dyjl中相应的人员的cdcs数据没有改变?
on kqjl
for update
as
DECLARE
@cdcs1 int,
@ztcs1 int,
@cdcs2 int,
@ztcs2 int,
@name varchar(16),
@cdate1 varchar(16),
@cdjl int,
@ztjl int
select @cdcs1=i.cdcs,@ztcs1=i.ztcs,@cdcs2=j.cdcs,@ztcs2=j.ztcs,@cdate1=i.cdate,@name=i.name
from kqjl i , deleted j where i.name=j.name and i.cdate=j.cdate
Update dyjl set cdcs=cdcs+(@cdcs1-@cdcs2) ,ztcs=2 where name=RTrim(@name) and dyID=substring(@cdate1,1,6)
dyid为年月(2006-8),cdate为年月日(2006-8-8), 为什么修改了kqjl中的cdcs一个值,dyjl中相应的人员的cdcs数据没有改变?