[步骤]

(@CustomerID int,@WareHouseID int,@sku nvarchar(50),@addTime datetime) SELECT TOP 1 ShipFee FROM dbo.RB_WareHouse_Inventory_SalesOrder_Log (NOLOCK)  where [CustomerID]=@CustomerID AND WareHouseID=@WareHouseID AND sku=@sku AND ShipTime<=@addTime order by ShipTime desc

数据库的 SKU 类型为 varchar，传入的 类型为 nvarchar 系统做了 类型转换 导致性能差 

[结果]

[期望]

指定传入的SKU 为varchar 和数据库保持一致