# Using Trigonometric Functions

#### Accessing and Changing Relational Data

Accessing and Changing Relational Data

### Using Trigonometric Functions

Microsoft® SQL Server™ 2000 provides trigonometric functions that return radians.

ACOS TAN
COS SIN
ATAN ASIN
ATN2
COT
##### ACOS and COS

Both ACOS and COS are trigonometric functions. The ACOS function returns the angle, in radians, whose cosine is the given float expression. The COS function returns the cosine of the specified angle, in radians, given the float expression. For example, this SELECT statement calculates the ACOS of -.997 and the COS for the value 1.134:

``````SELECT ACOS(-.997), COS(1.134)
``````

Therefore, the angle that measures 3.06411360866591 radians has a cosine value of -.997, and the angle measuring 1.134 radians has a cosine value of 1.134.

The valid ranges for ACOS are from -1 through 1.

##### ASIN and SIN

Both ASIN and SIN are trigonometric functions that use a float expression. The ASIN function calculates the angle, measured in radians, whose sine is the given float expression. The SIN function calculates the trigonometric sine value of the angle, measured in radians, as a float expression.

This example calculates the ASIN of -.7582 and the SIN of 5. The angle that measures -0.860548023283932 in radians has a sine value of -.7582 and the angle that measures 5 radians has a sine value of -0.958924274663138.

``````SELECT ASIN(-.7582), SIN(5)
``````

The valid ranges for ASIN are from -1 through 1.

##### ATAN, ATN2, TAN, and COT

The ATAN, ATN2, TAN, and COT functions are mathematical functions. The ATAN function returns the measurement of the angle, in radians, whose tangent is the given float expression. An angle having a tangent value of -27.29 measures

The ATN2 function returns the angle, in radians, for an angle whose tangent is between the two given float expressions. An angle with a tangent from 3.273 through 15 measures 0.214832755968629 in radians.

The TAN function returns the trigonometric tangent of the given float expression. An angle that measures 27.92 radians has a tangent of -0.36994766163616.

The COT function returns the trigonometric cotangent of the specified angle, in radians, specified in the given float expression. An angle of 97.1928 radians has a cotangent value of -5.02149424849997.

##### DEGREES

The DEGREES function returns a numeric expression, the measurement of an angle, in degrees, from the angle's measurement in radians. An angle measuring
``````SELECT DEGREES(-14.578)
``````SELECT RADIANS(10.75)