SQL Server Mathematical Functions-1

Mathematical Functions are built-in scalar functions that perform calculations depending on input values provided as arguments and return a numeric value.

We’ll go through the mathematical functions that SQL Server has to offer in this and the following posts.

SELECT ABS(-19.99)
Returns: 19.99
This function returns the absolute value of X.

SELECT ACOS(0)
Returns: 1.5707963267949
The above function takes a Cos value as an argument and returns a radian angle.
Only values between -1.00 and 1.00 are valid. No value is returned for values outside of this range, and ACOS will report a domain error.

SELECT ASIN(1)
Returns: 1.5707963267949
This function takes a Sin value as an argument and returns a radian angle.
Only values between -1.00 and 1.00 are valid. No value is returned for values outside of this range, and ASIN will report a domain error.

SELECT ATAN(1)
Returns: 0.785398163397448
The above function, which takes a Tan value as an input, returns the angle in radians. The type float or a type that transforms to a float expression implicitly.

SELECT ATN2(45.12,1.2)
Returns: 1.54420685014236
The above function returns the angle between the positive x-axis and the ray from the origin to the point (y, x), in radians, where x and y are the values of the two provided float expressions.

SELECT CEILING(6.8)
Returns: 7
The above function returns greatest integer value that is either less than or equal to X.

SELECT COS(0)
Returns: 1
The above function takes a radian angle as an input and returns the angle’s Cosine value. In other words, the trigonometric cosine of the supplied angle – measured in radians – in the specified statement is returned by this mathematical function.

The continuation post can be found here.

One comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s