SQL Server ASIN() Function

Summary: in this tutorial, you will learn how to use the SQL Server ASIN() function to return the arcsine of a number.

Introduction to the SQL Server ASIN() function

The arcsine function is the inverse function of the sine function. The arcsine function returns the angle of a sine in radians.

In SQL Server, you can use the ASIN() function to return an angle (in radians) of a specified sine.

The following shows the syntax of the ASIN() function:

ASIN(n)Code language: SQL (Structured Query Language) (sql)

In this syntax:

n is a float value you want to calculate the arcsine. The valid range of n is from -1 to 1.

The ASIN() function returns an angle (in radians) whose sine equals the n. If n is invalid, the ASIN() function will raise an error. If n is NULL, the ASIN() function will return NULL.

SQL Server ASIN() function examples

Let’s take some examples of using the SQL Server ASIN() function.

1) Basic SQL Server ASIN() function example

The following example uses the ASIN() function to return the arcsine of 1:

SELECT ASIN(1) angle;Code language: SQL (Structured Query Language) (sql)

Output:

angle
----------------
1.5707963267949Code language: SQL (Structured Query Language) (sql)

2) Using ASIN() function with variables

The following example uses the ASIN() function with variables:

DECLARE @value FLOAT;
SET @value = 0;

SELECT ASIN(@value) AS arcsine_value;Code language: SQL (Structured Query Language) (sql)

Output:

arcsine_value
-------------
0Code language: SQL (Structured Query Language) (sql)

In this example, we set the @value to 0 and then use the ASIN() function to calculate the arcsine of 0, which is zero radians.

Summary

Use the ASIN() function to return the arcsine of a number.

Was this tutorial helpful?