------------------ Windows Phones 7手机开发、.Net培训、期待与您交流! ----------------------
当查询语句直接转换时不会出现错误提示
select Convert(decimal,'2471.278')
select Convert(decimal,2471.278)
当在查询表的时候,使用CONVERT,如果是下面的这种就会提示:
消息 245,级别 16,状态 1,第 7 行
在将 varchar 值 '2471.278' 转换成数据类型 int 时失败。
---------------正确方法--------------
SELECT EMD.Material_Detail_Id,PMD.MaterialName,
CONVERT(decimal(10, 2),ISNULL(CASE EMD.Total WHEN '' THEN '0' ELSE EMD.Total END, '0')) AS Total
FROM dbo.Edf_Material_Detail AS EMD
LEFT OUTER JOIN dbo.Pd_MaterialDetail AS PMD ON PMD.MaterialDetail_Id = EMD.MaterialDetail_Id
---------------错误方法--------------
SELECT EMD.Material_Detail_Id,PMD.MaterialName,
CONVERT(decimal(10, 2),ISNULL(CASE EMD.Total WHEN '' THEN 0 ELSE EMD.Total END, 0)) AS Total
FROM dbo.Edf_Material_Detail AS EMD
LEFT OUTER JOIN dbo.Pd_MaterialDetail AS PMD ON PMD.MaterialDetail_Id = EMD.MaterialDetail_Id
------------------ Windows Phones 7手机开发、.Net培训、期待与您交流! ----------------------