消息 245,级别 16,状态 1,过程 xx,第 73 行在将 varchar 值 'xxx ' 转换成数据类,该怎么处理
日期：2014-05-17 浏览次数：20289 次
消息 245,级别 16,状态 1,过程 xx,第 73 行在将 varchar 值 'xxx ' 转换成数据类
[align=left]select p.PSCode,PSName,p.RegionCode,r.RegionName,PSAddress,LINkman,c.PollutantCode,g.DataMonth, (g.LetCapacity),c.PollutantName,c.PollutantTypeCode ,d.OutputCode
from Dictionary.PollutantCode C,BaseOperationData.WaterOutputPollutionMonthLet g,PSInfo.PSBaseInfo p ,Dictionary.Region r,PSInfo.WaterOutput d where g.PSCode = p.PSCode AND p.Status =0 AND g.PSCode = d.PSCode AND g.OutputCode =d.OutputCode
AND d.Status=0 AND p.RegionCode = r.RegionCode AND c.PollutantTypeCode IN(1,2) AND g.DeleteFlag=0 AND c.PollutantCode=011 AND c.PollutantTypeCode=1 AND DataMonth BETWEEN 201301 AND 201301[/align]
---------------------------------------------------------------------------------
消息 245，级别 16，状态 1，过程 ProcQueryFourPolluteLet，第 73 行
在将 varchar 值 'select p.PSCode,PSName,p.RegionCode,r.RegionName,PSAddress,LINkman,c.PollutantCode,g.DataMonth, (g.LetCapacity),c.PollutantName,c.PollutantTypeCode ,d.OutputCode
from Dictionary.PollutantCode C,BaseOperationData.WaterOutputPollutionMonthLet g,PSInfo.PSBaseInfo p ,Dictionary.Region r,PSInfo.WaterOutput d where g.PSCode = p.PSCode AND p.Status =0 AND g.PSCode = d.PSCode AND g.OutputCode =d.OutputCode
AND d.Status=0 AND p.RegionCode = r.RegionCode AND c.PollutantTypeCode IN(1,2) AND g.DeleteFlag=0 AND c.PollutantCode=011 AND c.PollutantTypeCode=1 AND DataMonth BETWEEN 201301 AND 201301 ' 转换成数据类型 int 时失败。
------解决方案--------------------
AND c.PollutantTypeCode IN(1,2) AND g.DeleteFlag=0
AND c.PollutantCode=011 AND c.PollutantTypeCode=1 AND DataMonth BETWEEN 201301 AND 201301
改为：
AND c.PollutantTypeCode IN('1','2') AND g.DeleteFlag=0
AND c.PollutantCode='011' AND c.PollutantTypeCode=1 AND DataMonth BETWEEN '201301' AND '201301'
[align=left]select p.PSCode,PSName,p.RegionCode,r.RegionName,PSAddress,LINkman,c.PollutantCode,g.DataMonth, (g.LetCapacity),c.PollutantName,c.PollutantTypeCode ,d.OutputCode
from Dictionary.PollutantCode C,BaseOperationData.WaterOutputPollutionMonthLet g,PSInfo.PSBaseInfo p ,Dictionary.Region r,PSInfo.WaterOutput d where g.PSCode = p.PSCode AND p.Status =0 AND g.PSCode = d.PSCode AND g.OutputCode =d.OutputCode
AND d.Status=0 AND p.RegionCode = r.RegionCode AND c.PollutantTypeCode IN(1,2) AND g.DeleteFlag=0 AND c.PollutantCode=011 AND c.PollutantTypeCode=1 AND DataMonth BETWEEN 201301 AND 201301[/align]
---------------------------------------------------------------------------------
消息 245，级别 16，状态 1，过程 ProcQueryFourPolluteLet，第 73 行
在将 varchar 值 'select p.PSCode,PSName,p.RegionCode,r.RegionName,PSAddress,LINkman,c.PollutantCode,g.DataMonth, (g.LetCapacity),c.PollutantName,c.PollutantTypeCode ,d.OutputCode
from Dictionary.PollutantCode C,BaseOperationData.WaterOutputPollutionMonthLet g,PSInfo.PSBaseInfo p ,Dictionary.Region r,PSInfo.WaterOutput d where g.PSCode = p.PSCode AND p.Status =0 AND g.PSCode = d.PSCode AND g.OutputCode =d.OutputCode
AND d.Status=0 AND p.RegionCode = r.RegionCode AND c.PollutantTypeCode IN(1,2) AND g.DeleteFlag=0 AND c.PollutantCode=011 AND c.PollutantTypeCode=1 AND DataMonth BETWEEN 201301 AND 201301 ' 转换成数据类型 int 时失败。
varchar?
数据
select
------解决方案--------------------
AND c.PollutantTypeCode IN(1,2) AND g.DeleteFlag=0
AND c.PollutantCode=011 AND c.PollutantTypeCode=1 AND DataMonth BETWEEN 201301 AND 201301
改为：
AND c.PollutantTypeCode IN('1','2') AND g.DeleteFlag=0
AND c.PollutantCode='011' AND c.PollutantTypeCode=1 AND DataMonth BETWEEN '201301' AND '201301'
免责声明： 本文仅代表作者个人观点，与爱易网无关。其原创性以及文中陈述文字和内容未经本站证实，对本文以及其中全部或者部分内容、文字的真实性、完整性、及时性本站不作任何保证或承诺，请读者仅作参考，并请自行核实相关内容。
