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]
For this COT Function demo, we use the below-shown data
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.
TIP: Please refer TAN Function article in SQL Server.
DECLARE @i float SET @i = 208.45 SELECT COT(@i)AS [SQL Cotangent] -- Calculating COT directly SELECT COT(0.24)AS [SQL Cotangent] -- Calculating COT directly SELECT COT(10.232)AS [SQL Cotangent] -- Calculating COT directly SELECT COT(1)AS [SQL Cotangent]
OUTPUT
ANALYSIS
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 [SQL Cotangent]
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]
OUTPUT