Summary: in this tutorial, you will learn how to use the SQL Server COT()
function to calculate the cotangent of a number.
Introduction to the SQL Server COT() function
In SQL Server, the COT()
function is a math function that returns the cotangent of a number.
Here’s the syntax of the COT()
function:
COT(n)
Code language: SQL (Structured Query Language) (sql)
In this syntax:
n
is the angle in radians for which you want to find the cotangent value.
The COT()
function returns the cotangent of the argument n
. If n
is NULL
, the COT()
function returns NULL
.
SQL Server COT() function examples
Let’s take some examples of using the COT()
function.
1) Basic COT() function example
The following example uses the COT()
function to calculate the cotangent of 1 radian:
SELECT COT(1) cotangent_value;
Code language: SQL (Structured Query Language) (sql)
Output:
cotangent_value
------------------
0.6420926159343306
Code language: SQL (Structured Query Language) (sql)
2) Using the COT() function with PI() function
The following example uses the COT()
function to find the cotangent of pi/4:
SELECT COT(PI()/4) cotangent_value;
Code language: SQL (Structured Query Language) (sql)
Output:
cotangent_value
---------------
1.0
Code language: SQL (Structured Query Language) (sql)
3) Using COT() function with table data
First, create a table called angles
to store angles in radians:
CREATE TABLE angles(
id INT IDENTITY PRIMARY KEY,
angle DEC(19,2)
);
Code language: SQL (Structured Query Language) (sql)
Second, insert some rows into the angles
table:
INSERT INTO
angles (angle)
VALUES
(NULL),
(PI() / 4),
(PI() / 2);
Code language: SQL (Structured Query Language) (sql)
Third, retrieve data from the angles
table:
SELECT
id,
angle
FROM
angles;
Code language: SQL (Structured Query Language) (sql)
Output:
id | angle
---+------
1 | NULL
2 | 0.79
3 | 1.57
(3 rows)
Code language: SQL (Structured Query Language) (sql)
Finally, calculate the cotangents of angles from the angles
table:
SELECT
id,
angle,
ROUND(COT(angle),0) tangent_value
FROM
angles;
Code language: SQL (Structured Query Language) (sql)
Output:
id | angle | tangent_value
---+-------+--------------
1 | NULL | NULL
2 | 0.79 | 1.0
3 | 1.57 | 0.0
(3 rows)
Code language: SQL (Structured Query Language) (sql)
Summary
- Use the
COT()
function to calculate the cotangent of a number.