sqlserver 實現根據上一行更新本行的數據

參考地址：http://www.noobyard.com/article/p-xasaezqk-dd.html   十分感謝此路大神

數據量30萬  符合執行條件的3萬  數據庫 sqlserver  工具 navicate

DECLARE cursor_jxsmb CURSOR FOR SELECT    id10value FROM EID100032_copy
OPEN cursor_jxsmb 
DECLARE @LAST DECIMAL (18, 2),@THIS DECIMAL (18, 2) 
FETCH NEXT FROM cursor_jxsmb INTO @THIS 
WHILE @@FETCH_STATUS = 0 
BEGIN
IF @THIS <> 0.00 
BEGIN
SET @LAST [email protected] 
END
ELSE
BEGIN
    UPDATE EID100032_copy SET id10value [email protected]
  WHERE
    CURRENT OF cursor_jxsmb 
END FETCH NEXT FROM cursor_jxsmb INTO @THIS 　　　　 
END CLOSE cursor_jxsmb 
DEALLOCATE cursor_jxsmb 

格式錯誤執行都會導致語法錯誤