Using Trigonometric Functions

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

Functions returning radians Use radians as input value
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 between -1 and 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 -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
-1.53416925536896 in radians.

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 between 3.273 and 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
-14.578 radians measures -835.257873741714090000 degrees.

SELECT DEGREES(-14.578)

  

RADIANS

The RADIANS function calculates the angle in radians given the angle’s measurement in degrees. To calculate the measurement in radians of an angle that measures 10.75 degrees, use:

SELECT RADIANS(10.75)

  

See Also

Mathematical Functions

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.