西安响应式网站设计,wordpress 对联广告,昆明企业为什么要做网站,网站源代码怎么下载【四舍五入取整截取】select round(54.56,0) 【向下取整截取】SELECT FLOOR(54.56) 【向上取整截取】SELECT CEILING(13.15)以下转自#xff1a;http://www.2cto.com/database/201209/156996.html--MSSQL取整函数的使用--两个整数相除将截断小数部分select 3/4,4/3,5/3--结果… 【四舍五入取整截取】select round(54.56,0) 【向下取整截取】SELECT FLOOR(54.56) 【向上取整截取】SELECT CEILING(13.15)以下转自http://www.2cto.com/database/201209/156996.html--MSSQL取整函数的使用--两个整数相除将截断小数部分select 3/4,4/3,5/3--结果 011--返回大于或等于所给数字表达式的最小整数SELECT CEILING(123.55), CEILING(123.45),CEILING(-123.45), CEILING(0.0)--结果 124124-1230-- www.2cto.com--四舍五入 round(a,b) -- 结果a 精确到小数点右 b位或是左 -b位select round(54.36,-2), round(54.36,-1),round(54.36,0), round(54.36,1),round(54.36,2)--结果 100.0050.0054.0054.4054.36---四舍五入 并转化为 整数select cast(round(56.361,0) as int),cast(round(56.561,0) as int)--结果 5657--举例使用---两个整数相除 舍弃小数部分( 全部都向前进位)declare dividend decimal(20,2), divisor decimal(20,2)set dividend3set divisor4select CEILING(dividend/divisor)--结果 1set dividend4set divisor3select CEILING(dividend/divisor)--结果 2set dividend5set divisor3select CEILING(dividend/divisor)--结果 2---两个整数相除 四舍五入到整数set dividend3set divisor4select cast(round(dividend/divisor,0) as int)--结果 1set dividend4set divisor3select cast(round(dividend/divisor,0) as int)--结果 1set dividend5set divisor3select cast(round(dividend/divisor,0) as int)--结果 2 【四舍五入取整截取】select round(54.56,0) 【向下取整截取】SELECT FLOOR(54.56) 【向上取整截取】SELECT CEILING(13.15)
