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