update mytable
set mytable.s_sum=case a.mykey when 1 then a.ord_col+b.ord_col else a.s_sum+b.ord_col end
from mytable as a left outer join v_mytable as b on a.mykey=b.mykey
where mytable.mykey=a.mykey+1
set mytable.s_sum=case a.mykey when 1 then a.ord_col+b.ord_col else a.s_sum+b.ord_col end
from mytable as a left outer join v_mytable as b on a.mykey=b.mykey
where mytable.mykey=a.mykey+1
你可以使用触发器:
主要语句可以这样,不知对否,你自己去试,对了给我加分。
select @YE=(SUM(收入)-SUM(支出)) FROM TABLE
SELECT @ID=ID,@SL=收入,@ZC=支出 FROM INSERTED
UPDATE TABLE SET 余额=@YE+@SL-@ZC WHERE ID=@ID
FOR INSERT
AS
DECLARE @YE INT,@SL INT,@ZC INT,@ID VARCHAR
SELECT @ID=ID,@SL=SL,@ZC=ZC FROM INSERTED
SELECT @YE=(SUM(SL)-SUM(ZC)) FROM TABLE1
UPDATE TABLE1 SET YE=@YE WHERE ID=@ID
form 表 a
order by a.TDAY你试试,我试过,成功。