{"id":3831,"date":"2024-04-08T08:25:51","date_gmt":"2024-04-08T01:25:51","guid":{"rendered":"https:\/\/www.sqlservertutorial.net\/?page_id=3831"},"modified":"2024-04-08T08:26:10","modified_gmt":"2024-04-08T01:26:10","slug":"sql-server-asin","status":"publish","type":"page","link":"https:\/\/www.sqlservertutorial.net\/sql-server-math-functions\/sql-server-asin\/","title":{"rendered":"SQL Server ASIN() Function"},"content":{"rendered":"\n

Summary<\/strong>: in this tutorial, you will learn how to use the SQL Server ASIN()<\/code> function to return the arcsine of a number.<\/p>\n\n\n\n

Introduction to the SQL Server ASIN() function #<\/a><\/h2>\n\n\n\n

The arcsine function is the inverse function of the sine<\/a> function. The arcsine function returns the angle of a sine in radians.<\/p>\n\n\n\n

In SQL Server, you can use the ASIN()<\/code> function to return an angle (in radians) of a specified sine. <\/p>\n\n\n\n

The following shows the syntax of the ASIN()<\/code> function:<\/p>\n\n\n

ASIN(n)<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this syntax:<\/p>\n\n\n\n
\n
n<\/code> is a float value you want to calculate the arcsine. The valid range of n<\/code> is from -1 to 1.<\/li>\n<\/ul>\n\n\n\n
The ASIN()<\/code> function returns an angle (in radians) whose sine equals the n<\/code>. If n<\/code> is invalid, the ASIN()<\/code> function will raise an error. If n<\/code> is NULL<\/code>, the ASIN()<\/code> function will return NULL<\/code>.<\/p>\n\n\n\n
SQL Server ASIN() function examples #<\/a><\/h2>\n\n\n\n
Let’s take some examples of using the SQL Server ASIN()<\/code> function.<\/p>\n\n\n\n
1) Basic SQL Server ASIN() function example #<\/a><\/h3>\n\n\n\n
The following example uses the ASIN()<\/code> function to return the arcsine of 1:<\/p>\n\n\n
SELECT<\/span> ASIN<\/span>(1<\/span>) angle;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
angle\r\n----------------<\/span>\r\n1.5707963267949<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
2) Using ASIN() function with variables #<\/a><\/h3>\n\n\n\n
The following example uses the ASIN()<\/code> function with variables:<\/p>\n\n\n
DECLARE<\/span> @value<\/span> FLOAT<\/span>;\nSET<\/span> @value<\/span> = 0<\/span>;\n\nSELECT<\/span> ASIN<\/span>(@value<\/span>) AS<\/span> arcsine_value;<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
Output:<\/p>\n\n\n
arcsine_value\r\n-------------<\/span>\r\n0<\/code><\/span>Code language:<\/span> SQL (Structured Query Language)<\/span> (<\/span>sql<\/span>)<\/span><\/small><\/pre>\n\n\n
In this example, we set the @value<\/code> to 0 and then use the ASIN()<\/code> function to calculate the arcsine of 0, which is zero radians.<\/p>\n\n\n\n
Summary #<\/a><\/h2>\n\n\n\n
\n
Use the ASIN()<\/code> function to return the arcsine of a number.<\/li>\n<\/ul>\n
\n\t
\n\t\t
Was this tutorial helpful?<\/div>\n\t\t
\n\t\t\t\n\t\t\t\t Yes <\/span>\n\t\t\t<\/button>\n\n\t\t\t\n\t\t\t\t No <\/span>\n\t\t\t<\/button>\n\t\t<\/div>\n\t<\/header>\n\n\t