Wednesday 7 September 2011

Sql Server some Mathamatical Functions

Select abs(-23) // output '23' Get absolute value 

Select ceiling(25.3) // output '26' get round the value 

Select Floor(45.8) // output '45' get round the value 

Select Exp(0) //get a exponential value of '0' 

Select Round(145.245874,3) //output 145.246 round a value 
after the no.of digit.

No comments:

Post a Comment