Mega Code Archive

 

Categories / MSSQL Tutorial / Math Functions

 

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>