Update temp Set qmye=@qmye,@qmye=Isnull(qcje,0)+Isnull(@qmye,0)+Isnull(skje,0)-Isnull(fkje,0)
回答 0
暂无回答
Dora
目前没有,这两种方式也可以实现效果
WITH A AS (SELECT ISNULL(QCJE,0)+ISNULL(QMYE,0)+ISNULL(SKJE,0)-ISNULL(FKJE,0) AS V_QMYE,ROWID FROM TEMP)
UPDATE TEMP,A SET TEMP.QMYE = A.V_QMYE WHERE TEMP.ROWID =A.ROWID ;
DECLARE
BEGIN
for a in ( SELECT Isnull(qcje,0)+Isnull(qmye,0)+Isnull(skje,0)-Isnull(fkje,0) as v_qmye,rowid FROM temp )
loop UPDATE temp SET qmye = a.v_qmye where rowid =a.rowid ;
end loop;
END;
目前没有,这两种方式也可以实现效果