深圳智汇创想科技有限公司

[步骤]

(@p1 bigint,@p2 nvarchar(8))SELECT top 1 ProductSKU,PackageUnitPrice FROM RB_Product_ProcurementPackage A (NOLOCK)        WHERE A.CustomerID = @p1 AND A.ProductSKU = @p2

(@p1 bigint,@p2 nvarchar(7))SELECT top 1 ProductSKU,A.Price FROM RB_Product_Picking P (NOLOCK) INNER JOIN RB_Picking A (NOLOCK)  on A.ID= P.PickingID   WHERE A.CustomerID = @p1 and P.ProductSKU = @p2;

[结果]

[期望]

建议指定正确的参数类型