The SQL TAN function is one of the SQL Server Mathematical Function which is used to calculate the trigonometry Tangent for the specified expression. The mathematical formula for this function is: TAN(x) = Length of the Opposite Side / Length of the Adjacent Side
SQL TAN Function Syntax
In SQL Server, The basic syntax of the TAN Function is:
|
1 2 3 |
-- SQL Server TAN Syntax SELECT TAN (Float_Expression) FROM [Source] |
In this article we will show you, How to write TAN Function in SQL Server with example. For this, We are going to use the below shown data
SQL TAN Function Example 1
TAN Function is used to calculate the Tangent value for the given angle. The following query will show multiple ways to use TAN function.
T-SQL CODE
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
DECLARE @i float SET @i = 208.45 SELECT TAN(@i)AS [SQL Tangent] -- Calculating TAN directly SELECT TAN(0.24)AS [SQL Tangent] -- Calculating TAN directly SELECT TAN(0)AS [SQL Tangent] -- Calculating TAN directly SELECT TAN(1)AS [SQL Tangent] |
OUTPUT
ANALYSIS
Below lines of code is used to declare float variable and assigning the value.
|
1 2 |
DECLARE @i float SET @i = 208.45 |
In the below statement, We used TAN function to calculate the Tangent value for the variable @i (It means TAN(208.45)). We also assigned new name to that result as ‘SQL Tangent’ using SQL ALIAS Column.
|
1 |
SELECT TAN(@i)AS [SQL Tangent] |
In the next statements, We used the TAN Function directly on the float values.
SQL TAN Function Example 2
In this example, We are going to calculate the Tangent value for all the records present in [Tax Amount] and [Service Grade] using TAN Function.
T-SQL CODE
|
1 2 3 4 5 6 7 |
SELECT [EnglishProductName] ,[SalesAmount] ,[TaxAmt] ,TAN([TaxAmt]) AS [Tax Tangent] ,[Service Grade] AS Grade ,TAN ([Service Grade]) AS [TAN Function] FROM [Mathemetical Functions] |
OUTPUT
Thank You for Visiting Our Blog
Leave a Reply