[步骤]
(@__p_4 int,@__customerId_0 int,@__from_1 datetime,@__to_2 datetime,@__lastId_3 bigint)SELECT TOP(@__p_4) [r].[CustomerID], [r].[ID], [r].[AddAdminID], [r].[AddAdminName], [r].[AddTime], [r].[AllBuyBoxNum1], [r].[AllBuyBoxNum2], [r].[AllBuyBoxNum3], [r].[ASINorItemID], [r].[Attention], [r].[AvgDailySales], [r].[BadReviewNum], [r].[BasePrice], [r].[BeforeYesterdaySessions], [r].[BeforeYesterdayUnitSessionPercentage], [r].[BiSycnCompleteTime], [r].[BrandType], [r].[BusinessAdminID], [r].[BusinessAdminName], [r].[BuyBoxNum1], [r].[BuyBoxNum2], [r].[BuyBoxNum3], [r].[BuyBoxUpdateTime], [r].[DefaultWarehouseID], [r].[DiscountEndTime], [r].[DiscountSalesPrice], [r].[DiscountStartTime], [r].[FBASeller_Num], [r].[FirstLegShippingType], [r].[HeretoforeSessions], [r].[HeretoforeUnitSessionPercentage], [r].[HolidaysID], [r].[IsAmazonKeywordRank], [r].[IsAmazonListingReview], [r].[IsBiSycnComplete], [r].[IsBuyBox], [r].[IsClearStock], [r].[isDelete], [r].[IsFBA], [r].[IsOffShelf], [r].[IsRecommendOcean], [r].[IsRemind], [r].[IsSalesRank], [r].[IsTiming], [r].[LastDownTiming], [r].[LastReviewCollectionTime], [r].[LastSynReviewTime], [r].[LastUpTiming], [r].[ListingPrice], [r].[ListingSoldNum], [r].[LowestPriceAllBuyBoxNum1], [r].[LowestPriceAllBuyBoxNum2], [r].[LowestPriceAllBuyBoxNum3], [r].[LowestPriceBuyBoxNum1], [r].[LowestPriceBuyBoxNum2], [r].[LowestPriceBuyBoxNum3], [r].[OnShelfMode], [r].[OptionsIDs], [r].[OrderSourceID], [r].[OrderSourceParentSKU], [r].[OrderSourceSKU], [r].[OrdinaryAllBuyBoxNum1], [r].[OrdinaryAllBuyBoxNum2], [r].[OrdinaryAllBuyBoxNum3], [r].[OrdinaryBuyBoxNum1], [r].[OrdinaryBuyBoxNum2], [r].[OrdinaryBuyBoxNum3], [r].[ParameterIDs], [r].[ParameterValues], [r].[PlanId], [r].[PreDiscountPrice], [r].[rankClassName], [r].[rankNum], [r].[rankQTNum], [r].[rankSQNum], [r].[rankZTNum], [r].[ReportsSynDate], [r].[ReportsSynStatus], [r].[ReviewFiveStar], [r].[ReviewFourStar], [r].[ReviewNum], [r].[ReviewOneStar], [r].[ReviewStar], [r].[ReviewThreeStar], [r].[ReviewTwoStar], [r].[ReviewUnReadNum], [r].[RobBuyBox], [r].[RobBuyBoxType], [r].[SKU], [r].[SellerType], [r].[SevenDayDayReviewNum], [r].[Standard], [r].[SynTime], [r].[ThreeDayReviewNum], [r].[ToBuyBoxProduct], [r].[TotalAvgCPC], [r].[TotalClicks], [r].[TotalImpressions], [r].[TotalSpend], [r].[UPCorEAN], [r].[UpdateTime], [r].[YesterdayAvgCPC], [r].[YesterdayClicks], [r].[YesterdayImpressions], [r].[YesterdaySessions], [r].[YesterdaySpend], [r].[YesterdayUnitSessionPercentage] FROM [RB_Product_OrderSourceSKU] AS [r] WITH (NOLOCK) WHERE ((([r].[CustomerID] = @__customerId_0) AND ([r].[UpdateTime] >= @__from_1)) AND ([r].[UpdateTime] < @__to_2)) AND ([r].[ID] > @__lastId_3) ORDER BY [r].[ID]
[结果]
[期望]
少量 从 读库 同步数据
