|
|
Function Name
|
.NET Framework Method
|
Example
|
|
ABS
|
System.Math.Abs
|
SELECT ABS(-1.0), ABS(0.0), ABS(1.0)
|
|
ACOS
|
System.Math.Acos
|
SELECT ACOS(0.0), ACOS(-1), ACOS(1.01)
|
|
ASIN
|
System.Math.Asin
|
SELECT ASIN(-1.01), ASIN(-1.0), ASIN(0.1472738)
|
|
ATAN
|
System.Math.Atan
|
SELECT ATAN(0),ATAN(-45.01),ATAN(-181.01)
|
|
CEILING
|
System.Math.Ceiling
|
SELECT CEILING(123.45), CEILING(-123.45), CEILING(0.0)
|
|
COS
|
System.Math.Cos
|
SELECT COS(-1.01), COS(-1.0), COS(14.78)
|
|
EXP
|
System.Math.Exp
|
SELECT EXP(378.615345498)
|
|
FLOOR
|
System.Math.Floor
|
SELECT FLOOR(123.45), FLOOR(-123.45)
|
|
LOG
|
System.Math.Log
|
|
|
LOG10
|
System.Math.Log10
|
|
|
POWER
|
System.Math.Pow
|
SELECT POWER(2.0, -10000.0), POWER(10,10), POWER(100,100)
|
|
ROUND
|
System.Math.Round
|
SELECT ROUND(123.9994), ROUND(123.9995, 2)
|
|
SIGN
|
System.Math.Sign
|
SELECT SIGN(123.45), SIGN(-123.45)
|
|
SIN
|
System.Math.Sin
|
SELECT SIN(-1.01), SIN(-1.0), SIN(14.78)
|
|
SQRT
|
System.Math.Sqrt
|
SELECT SQRT(1), SQRT(2), SQRT(3), SQRT(4), SQRT(-1)
|
|
TAN
|
System.Math.Tan
|
SELECT TAN(3.1415926535897931)
|
|
|