SQL中的decimal类型的要让其空该如何做
SQL中的decimal类型的要让其空该怎么做
select isnull(score, ' ') as score from A
score是decimal这个类型的话,报转换类型出错,帮帮忙,大家
------解决方案--------------------
这样:
select isnull(score,0.0) as score from A
select isnull(score, ' ') as score from A
score是decimal这个类型的话,报转换类型出错,帮帮忙,大家
------解决方案--------------------
这样:
select isnull(score,0.0) as score from A