I am going to continue my series of short articles or tidbits on Transaction SQL math functions. Most, if not all, of these functions have been in the product before the release of SQL Server 2005.
I am very proud of my daughter making the advance math class in sixth grade. I am dedicating these blogs to her hard class work and love of the subject.
I will be exploring the CEILING() function today. This function takes as input a expression in either exact numeric or approximate numeric form. This does not include the BIT data type. It returns the smallest integer greater than, or equal to, the specified numeric expression as output.
The example below tests the CEILING() function with three different inputs: negative numbers, positive numbers and a null value.
|
1 2 3 4 5 6 7 8 9 10 |
-- -- The CEILING Function -- -- Ceiling >= (next larger integer) SELECT CEILING(-10.45) AS NEGATIVE, CEILING(10.55) AS POSITVE, CEILING(NULL) AS UNKNOWN; GO |
The output from the test is listed below.
|
1 2 3 4 5 |
output: NEGATIVE POSITVE UNKNOWN ----------- ----------- ----------- -10 11 NULL |
In summary, this function will return the next integer greater than or equal to the numeric expression.
