Question

从数据类型 varchar 转换为 numeric 时出错

SELECT T2.FBillNo,FDate ,T3.FNumber 物料代码,t1.FQty 基本单位实发数量,t3.F_102 包装系数,
t1.FEntrySelfB0191 出库单件数
, round(t1.FQty%t3.F_102,2) 余数
,round(t1.FQty/t3.F_102,0) 换算件数
,round(t1.FQty/t3.F_102,0)+'件'+round(t1.FQty%t3.F_102,2) + '盒'
FROM ICStockBillEntry T1
LEFT JOIN ICStockBill T2 ON T1.FInterID=T2.FInterID
LEFT JOIN t_ICItem T3 ON T3.FItemID=T1.FItemID
WHERE T2.FTranType=21
and t3.F_102<>0
AND T2.FBillNo = '180120002'

Answer 1

numeric 是数值类型,看你插入的都是字符..所以,你要在有numeric那一列插入数值.