Trigonometry

A large number of trigonometry functions are provided by SQL Math, many of which are already implemented in Microsoft SQL Server.  To ensure easy differentiation a "long" function name has been used in SQL Math.  This ensures a clear distinction between current and potential future MS SQL Server trigonometry functions and SQL Math trigonometry functions.  Abbreviated functions such as  COS relate ONLY to the Microsoft function while full function names such as Cosine are the SQL Math implementation.  Similarly, ATan is the SQL Server implementation while InverseTangent is the SQL Math implementation.  However, it is possible to adjust the SQL Math function names to be any format of your choosing, see Deploying SQL Math.

Of the trigonometry functions already implemented in Microsoft SQL Server, SQL Server's functions have tested to be faster to execute in queries.  However, SQL Math may prove to be more accurate results in some situations, so please evaluate the implementation before making a decision on which to use.

Functions Parameters Description
Cosecant Double radian Cosecant of an angle in radian.
Cosine Double radian Cosine of an angle in radian.
Cotangent Double radian Cotangent of an angle in radian.
DegreeToGrad Double degree Converts a degree (360-periodic) angle to a grad (400-periodic) angle.
DegreeToRadian Double degree Converts a degree (360-periodic) angle to a radian (2*Pi-periodic) angle.
GradToDegree Double grad Converts a grad (400-periodic) angle to a degree (360-periodic) angle.
GradToRadian Double grad Converts a grad (400-periodic) angle to a radian (2*Pi-periodic) angle.
HyperbolicCosecant Double radian Hyperbolic Cosecan.
HyperbolicCosine Double radian Hyperbolic Cosine.
HyperbolicCotangent Double radian Hyperbolic Cotangent.
HyperbolicSecant Double radian Hyperbolic Secant.
HyperbolicSine Double radian Hyperbolic Sine.
HyperbolicTangent Double radian Hyperbolic Tangent in radian.
InverseCosecant Double radian Arc Cosecant in radian.
InverseCosine Double radian Arc Cosine in radian.
InverseCotangent Double radian Arc Cotangent in radian.
InverseHyperbolicCosecant Double radian Hyperbolic Arc Cosecant.
InverseHyperbolicCosine Double radian Hyperbolic Area Cosine.
InverseHyperbolicCotangent Double radian Hyperbolic Arc Cotangent.
InverseHyperbolicSecant Double radian Hyperbolic Area Secant.
InverseHyperbolicSine Double radian Hyperbolic Area Sine.
InverseHyperbolicTangent Double radian Hyperbolic Area Tangent.
InverseSecant Double radian Arc Secant in radian.
InverseSine Double radian Arc Sine in radian.
InverseTangent Double radian Arc Tangent in radian.
RadianToDegree Double radian Converts a radian (2*Pi-periodic) angle to a degree (360-periodic) angle.
RadianToGrad Double radian Converts a radian (2*Pi-periodic) angle to a grad (400-periodic) angle.
Secant Double radian Secant of an angle in radian.
Sine Double radian Sine of an angle in radian.
Tangent Double radian Tangent of an angle in radian.

Purchase SQL Math