SQL Server - COT() Function

The SQL Server (Transact-SQL) COT() function returns trigonometric cotangent of an angle (angle should be in radians). In special cases it returns the following:

• If x is 0, then an error is returned.

Syntax

COT(x)

Parameters

Return Value

Returns the trigonometric cotangent of an angle.

Example 1:

The example below shows the usage of COT() function.

SELECT COT(1);
Result: 0.6420926159343306

SELECT COT(2);
Result: -0.45765755436028577

SELECT COT(3);
Result: -7.015252551434534

SELECT COT(-1);
Result: -0.6420926159343306

SELECT COT(-2);
Result: 0.45765755436028577

SELECT COT(-3);
Result: 7.015252551434534

SELECT COT(PI());
Result: -8165619676597685

Example 2:

Consider a database table called Sample with the following records:

The statement given below can be used to calculate the trigonometric cotangent value of column x.

SELECT *, COT(x) AS COT_Value FROM Sample;

This will produce the result as shown below: