ASIN() Function in SQL Server

ASIN() function :

This function in SQL Server is used to return the arc sine or the inverse sine of a specified value. Input to the arc-sine function should must be in between -1 and 1 (inclusive), otherwise this function returns NULL.

Features :

• This function is used to find the arc sin or the inverse sin of a specified value.
• This function accepts a single parameter.
• The range of accepted parameter is in between -1 and 1 (inclusive), otherwise this function returns NULL.
• The returned value will be in radians.

Syntax :

SELECT ASIN(number);

Parameter :

This method accepts a parameter as given below:

• number: Specified numeric value whose inverse sine is going to be returned.

Returns :

It returns the arc sine or the inverse sine of a specified value.

Example-1 :

Getting the inverse sine of a specified value -1

SELECT ASIN(-1);

Output :

-1.5707963267948966

Example-2 :

Getting the inverse sine of a specified value 1

SELECT ASIN(1);

Output :

1.5707963267948966

Example-3 :

Using ASIN() function with a variable and getting the inverse sine of a specified value 0.

DECLARE @Parameter_Value INT;
SET @Parameter_Value = 0;
SELECT ASIN(@Parameter_Value);

Output :

0.0

Example-4 :

Using ASIN() function with a variable and getting the inverse sine of a specified float value “0.45”.

DECLARE @Parameter_Value float;
SET @Parameter_Value = 0.45;
SELECT ASIN(@Parameter_Value);

Output :

0.46676533904729639

Application :

This function is used to return the arc sine or the inverse sine of a specified value.