[步骤]
(@CustomerID0 int,@DeleteStatus1 int,@Id2 int)SELECT TOP 5000 [ID] AS [Id] , [SKU] AS [SKU] , [AddTime] AS [AddTime] , [ProductState] AS [ProductState] , [IsGroup] AS [IsGroup] FROM [RB_Product] WITH(NOLOCK) WHERE ((( [CustomerID] = @CustomerID0 ) AND ( [DeleteStatus] = @DeleteStatus1 )) AND ( [ID] < @Id2 ))ORDER BY [ID] DESC
(@CustomerID0 int,@DeleteStatus1 int,@Id2 int,@MethodConst3 nvarchar(4000),@MethodConst4 nvarchar(4000))SELECT TOP 1000 [p].[ID] AS [ID] , [p].[SKU] AS [SKU] , ISNULL([pa].[NoSaleCountry],@MethodConst3) AS [NoSaleCountry] , ISNULL([pa].[NoSalePlatform],@MethodConst4) AS [NoSalePlatform] FROM [RB_Product] [p] WITH(NOLOCK) Inner JOIN [RB_Product_Admin] [pa] WITH(NOLOCK) ON (( [p].[CustomerID] = [pa].[CustomerID] ) AND ( [p].[SKU] = [pa].[SKU] )) WHERE ((( [p].[CustomerID] = @CustomerID0 ) AND ( [p].[DeleteStatus] = @DeleteStatus1 )) AND ( [p].[ID] > @Id2 ))ORDER BY [p].[ID] ASC 也有同样问题

[结果]
[期望]
1.能否通过ID 范围 去同步数据,返回的数据在程序内部排序
2.建议产品库 系统上有大量的独立库 建议从其他库读取数据