SQL COT FUNCTION 1

SQL COT Function

The SQL COT Function is a Mathematical Function that calculates the trigonometry Cotangent for the specified expression. The syntax of the SQL Server COT Function is

SELECT COT (Float_Expression)
FROM [Source]

SQL COT Function Example 1

The mathematical formula for this function is COT(x) = 1 / TAN(x). The COT Function calculates the Cotangent value for the given angle. The following query shows you multiple ways to use the COT function.

Please refer TAN Function article in SQL Server. For this COT Function demo, we use the Math Table data

DECLARE @i float
SET @i = 208.45

SELECT COT(@i)AS [SQLCotangent]

-- Calculating COT directly
SELECT COT(0.24)AS [SQLCotangent]

-- Calculating COT directly
SELECT COT(10.232)AS [SQLCotangent]

-- Calculating COT directly
SELECT COT(1)AS [SQLCotangent]
SQL COT FUNCTION 1

We used the COT function to calculate the Cotangent value for the variable @i. It means COT(208.45) and assigned the name ‘Cotangent’ using ALIAS.

SELECT COT(@i)AS [SQLCotangent]

SQL COT Function Example 2

We are going to calculate the Cotangent value for all the records present in [Tax Amount] and [Service Grade] using COT Mathematical Function.

SELECT [EnglishProductName]
      ,[SalesAmount]
      ,[TaxAmt]
      ,COT([TaxAmt]) AS [Tax Cotangent]
      ,[Service Grade] AS Grade
      ,COT ([Service Grade]) AS [COT Function] 
  FROM [Mathemetical Functions]
SQL COT FUNCTION 2