[结果]
(@CustomerID0 int,@ToWareHouseID1 int,@OrderSourceType2 int,@Country3 nvarchar(4000),@OrderSourceID4 int)SELECT [wt].[CustomerID] AS [CustomerID] , [wt].[OrderSourceType] AS [OrderSourceType] , [io].[OrderSourceID] AS [OrderSourceID] , [io].[OrderCode] AS [OrderCode] , [io].[Country] AS [Country] , [wt].[SKU] AS [SKU] , [wt].[AddTime] AS [AddTime] , [wt].[UpdateTime] AS [UpdateTime] , [wt].[HeadTripFreight] AS [HeadTripFreight] , [wt].[ToWareHouseID] AS [WareHouseID] , [wt].[FromWareHouseID] AS [FromWareHouseID] , [t].[TransportName] AS [TransportName] FROM [RB_WareHouse_Inventory_Transfer_Log_HeadTripFreight] [wt] WITH(NOLOCK) Left JOIN [RB_OrderInfo] [io] WITH(NOLOCK) ON (( [wt].[OrderCode] = [io].[OrderCode] ) AND ( [wt].[OrderSourceID] = [io].[OrderSourceID] )) Left JOIN [RB_Transport] [t] WITH(NOLOCK) ON (( [io].[TransportID] = [t].[ID] ) AND ( [io].[CustomerID] = [t].[CustomerID] )) WHERE (((((( [wt].[CustomerID] = @CustomerID0 ) AND ( [wt].[ToWareHouseID] = @ToWareHouseID1 )) AND ( [wt].[OrderSourceType] = @OrderSourceType2 )) AND ( [wt].[Country] = @Country3 )) AND ( [wt].[OrderSourceID] = @OrderSourceID4 )) AND ([wt].[SKU] IN ('13796343')) )
[期望]
一、没有索引导致排序查询有问题，已经让高发加上索引，点击排序可以正常查看