禁用复制SET NOCOUNT ON ; DECLARE @SalesQuotaKey Bigint DECLARE MY_Cur CursorFor SELECTTOP 1000000 SalesQuotaKey FROM FactSalesQuotaAudit WHERE SalesAmountQuota<500000 ORDERBY SalesAmountQuota ASC OPEN MY_Cur FETCHNEXTFROM MY_Cur INTO @SalesQuotaKey WHILE(@@FETCH_STATUS = 0 ) BEGIN UPDATE FactSalesQuotaAudit SET SalesAmountQuota = SalesAmountQuota + 100000 WHERE SalesQuotaKey = @SalesQuotaKey FETCHNEXTFROM MY_Cur INTO @SalesQuotaKey END CLOSE MY_Cur DEALLOCATE MY_Cur 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.20.21.22.23.24.25.26.27.28.29.
亿华智慧云