gxx13285640837
洞妖洞妖呼叫洞拐
2017-07-27 01:30
采纳率: 76.9%
浏览 3.2k

“)”附近有语法错误,这有什么错误啊,没看懂,求大神们看一下

select OperateDt,WorkShopVch, FurnaceNoVch,WeightDbl,TOGNameVch,MasterNameVch,a,
(case when a*100=0 then 0 else convert(varchar ,(a/WeightDbl)*100) +'%' ) as A
from View_YBrokenRecordList 图片说明

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • u014074697
    张大教主 2017-07-27 01:40
    已采纳
    //case then else end 语法不完整,试一下
    select OperateDt,WorkShopVch, FurnaceNoVch,WeightDbl,TOGNameVch,MasterNameVch,a,
    (case when a*100=0 then 0 else convert(varchar ,(a/WeightDbl)*100) +'%'  end ) as A
    from View_YBrokenRecordList 
    
    点赞 评论

相关推荐