What is the CEILING() function SQL server?
The CEILING function returns the smallest integer value that is greater than or equal to a number.
Syntax
CEILING(number)
Parameter
number: a numeric value
Example
This example shows the CEILING function being applied to a positive value. It returns 26 because it is the smallest integer greater than or equal to the number.
SELECT CEILING(25.75);
Example
This example shows the CEILING function being applied to a negative value. It returns -29 because it is the smallest integer greater than or equal to the number.
SELECT CEILING(-29.61);
Example
In this example, the CEILING function is applied to a positive integer. It returns 19 because it is the smallest integer greater than or equal to the number.
SELECT CEILING(19);