TAN() and COT() Function in SQL Server

1. TAN() Function :
The TAN() function returns the tangent of a number.

Syntax :

TAN(number)

Parameter : Required. A numeric value.
number : It is a numeric value.
Returns : It returns the float_expression of the tangent of a number.

Example-1 :
When the arguments holds a positive number.

SELECT TAN(3.25);

Output :

0.10883402551332971

Example-2 :
When the arguments holds a negative number.

SELECT TAN(-3.25);

Output :

-0.10883402551332971

Example-3 :
When the PI() function is the argument.

SELECT TAN(PI());
         OR
DECLARE @angle FLOAT;  
SET @angle = PI();  
SELECT 'The TAN of the angle is: ' + CONVERT(VARCHAR, TAN(@angle)); 

Output :

The TAN of the angle is: -1.22465e-016

Example-4 :
When the argument passing as a expressions.

SELECT TAN(5.2 + 1.4);

Output :

0.32785800671313348

2. COT() Function :
The COT() function returns the cotangent of a number.

Syntax :

COT(number)

Parameter : Required. A numeric value.
number : It is a numeric value.
Returns : It returns the cotangent of a number.

Example-1 :
When the arguments holds a positive number.

SELECT COT(4);

Output :

0.86369115445061673

Example-2 :
When the argument is a fractional component.

SELECT COT(2.53);

Output :

-1.4259392442208509

Example-3 :
When the argument is an expression.

SELECT COT(3 + 1);

Output :

0.86369115445061673

Example-4 :
When the PI() function is the argument.

Select COT(PI());
         OR
DECLARE @angle FLOAT;  
SET @angle = PI();  
SELECT 'The COT of the angle is: ' + CONVERT(VARCHAR, COT(@angle));

Output :

The COT of the angle is: -8.16562e+015

sanjoy_62

Follow

Improve

Article Tags :

• SQL
• DBMS-SQL
• SQL-Server