sql 有小数时就显示小数,没有小数显示整数:
SELECT cast(7.50 as float) as [col]
print: 7.5
SELECT cast(8.00 as float) as [col]
print: 8
SELECT cast(8.03 as float) as [col]
print: 8.03
Sql Service 数据库截取小数
最新推荐文章于 2020-06-04 18:12:17 发布
sql 有小数时就显示小数,没有小数显示整数:
SELECT cast(7.50 as float) as [col]
print: 7.5
SELECT cast(8.00 as float) as [col]
print: 8
SELECT cast(8.03 as float) as [col]
print: 8.03