The SQL Server ATN2 function is a Mathematical Function that returns the angle between the positive x-axis and the line from the origin to the point (y, x). The syntax of the ATN2 Function is.
SELECT ATN2 (Float_Expression, Float_Expression) FROM [Source]
For this ATN2 Function demo, we use the below data
SQL ATN2 Function Example
The ATN2 function finds the angle between the positive x-axis and the line from the origin to the point (y, x). Here, the x and y values are the two-argument we are going to provide for the ATN2 function. The following Mathematical Function query shows multiple ways to use this one.
DECLARE @i Float = 50.05, @j Float = 200.05 SELECT ATN2(@i, @j) AS [ATN2 Function] SELECT ATN2(100.27, 50.27) AS [ATN2 Function] SELECT ATN2(22.45 + 77.55, 100) AS [ATN2 Function]
We used the ATN2 function to find the angle between @i and @j and assigned a new name, ‘ATN2 Function’, using ALIAS.
SELECT ATN2(@i, @j) AS [ATN2 Function]
In this SQL example, we will calculate the angle between the values present in [Standard Cost] and [Sales Amount].
SELECT [EnglishProductName] ,[Color] ,[StandardCost] ,[SalesAmount] ,ATN2([StandardCost], [SalesAmount]) AS [ATN2 Function] FROM [Mathemetical Functions]