禁用 SQL 游标，告诉你外面听不到的原因
复制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.
THE END
