SQL SERVER ASIN AND RADIANS FUNCTION

SQL SERVER ASIN AND RADIANS FUNCTION

--ALRIGHT ALL, TODAY WE WILL INVESTIGATE THE ASIN AND RADIANS FUNCTIONS

--LET US BEGIN

SELECT ASIN(RADIANS(58));

--NOW WE WILL TRY IT WITH A RADIAN OF 90 DEGREES

SELECT ASIN(RADIANS(90));

--THE ASIN FUNCTION SHOULD ALWAYS BE USED IN CONJUNCTION WITH THE RADIANS FUNCTION

--THAT IS IT.

/* hI ALL, TODAY WE ARE LOOKING AT THE ARC SINE FUNCTION WHICH CALCULATES DATA FROM
-114 RADIANS TO +114 RADIANS.
LET US BEGIN */

SELECT ASIN(RADIANS(-114));

/* AS YOU CAN SEE BELOW -114 RADIANS IN ASIN GIVES ONE -1.57 ASIN */

SELECT ASIN(RADIANS(114));

/* 114 RADIANS IN ASIN BELOW GIVES ONE 1.57 ASIN.
ANYTHING OUTSIDE THIS RANGE FLAGS AS AN ERROR AS I WILL NOW DISPLAY. */

SELECT ASIN(RADIANS(-115));

SELECT ASIN(RADIANS(115));

/* THE MESSAGE HAS DISPLAYED Msg 3623, Level 16, State 1, Line 1
An invalid floating point operation occurred. AS THE ERROR MESSAGE.
THAT IS IT. */