读书人

这样为什么不能不四舍五入?该如何处理

发布时间: 2012-01-02 22:40:04 作者: rapoo

这样为什么不能不四舍五入?

SELECT ROUND (15375/100, 0) as a
为什么不得到154

[解决办法]
SELECT ROUND (15375.0/100, 0) as a

[解决办法]
SELECT ROUND (15375*0.01, 0) as a

[解决办法]
SELECT cast(ROUND (15375*1.0/100, 0) as int) as a
[解决办法]
SELECT cast(ROUND (15375.0/100, 0) as int)as a

[解决办法]
SELECT cast(ROUND (15375*1.0/100, 0) as int) as a

读书人网 >SQL Server

热点推荐