SqlServer中用到的是ceiling函数: SELECT CEILING($123.45), CEILING($-123.45), CEILING($0.0) GO 下面是结果集: --------- --------- ------------------------- 124.00 -123.00 0.00 (1 row(s) affected)