Math Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. Math Functions
  4. CEILING function returns the value representing the smallest integer that is greater-than or equal to the input_number
3>
4>
5> SELECT CEILING(SQRT(2.0*ABS(1985.0)*ABS(-8.0)/ABS(0.20)))
6> GO
------------------------
                     399
(1 rows affected)
1>