SQL TAN Function

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:

-- 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

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.

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.

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

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