[步骤]
(@P0 bigint,@P1 datetime2,@P2 datetime2)WITH selectTemp AS (SELECT TOP 100 PERCENT ROW_NUMBER() OVER (ORDER BY id ASC) as __row_number__, id,customerID,orderSourceSKUID,orderSourceID,orderSourceName,orderSourceCountry,orderSourceSKU,sku,publishTime,checkStatus,checkTime,checkUserID,checkUserName,isPushTransferFba,isDelete,remarks,addTime,addUserID,addUserName,updateTime,updateUserName,updateUserID,pushType,isAmazonBanned,replaceOrderSourceId,replaceOrderSourceName,replaceOrderSourceCountry,transToFbaPendingTime,asin,ratingStar,commentCount,transferedFbaTime,transferedFbaOrderSouceSku,TransferedFbaOrderSouceId,firstLeadSubmitTime,firstLeadSubmitNum,fbaPriceDifference,fbaPriceDifferenceRate,productSizeLevel,tryNum,hasPredicted,predictedTime,saleNumWeek1,saleNumWeek2,saleNumDay30,saleNumDay90,predictedProbability,billingFirstLeg,profitMarginTo30,isPredictedOk,predictAgainTime,listingStatus,listingPrice,discountSalesPrice,yesterdaySaleNum,yesterdayBeforeSaleNum,threeDayAgoSaleNum,isStock,fbaPrice,isClearProductLogo,modelResult,runRemarks,smartRecommendLevel,syntheticRatingStar,refundRate90,listingTags,predictionModelType,autoAudit FROM RB_Amazon_AutoFba_Check WHERE (id > @P0 AND updateTime >= @P1 AND updateTime < @P2) ORDER BY id ASC) SELECT * FROM selectTemp WHERE __row_number__ BETWEEN 1 AND 500 ORDER BY __row_number__
[结果]
[期望]
添加nolock