October 20, 2011

CEILING function in SQL Server

It returns the next integer larger than the input value.

image 
Here input value is 99.89 so next integer value is 100 so that’s why 100 is coming as output.
Let’s try another example.

image

The output of 9/5.0 will be 1.8 so next integer is 2 that is what coming in above output.
That’s It
Enjoy Learning.

No comments:

Post a Comment