MSSQL Numeric Functions

19 functions

ABSABS(n)

Returns the absolute value.

CEILINGCEILING(n)

Returns the ceiling.

FLOORFLOOR(n)

Returns the floor.

ROUNDROUND(n, d [, f])

Rounds or truncates to d decimal places.

POWERPOWER(x, y)

Returns x raised to the power of y.

SQRTSQRT(n)

Returns the square root.

SQUARESQUARE(n)

Returns the square of n.

EXPEXP(n)

Returns e raised to the power of n.

LOGLOG(n [, base])

Returns the natural logarithm or base-specified logarithm.

LOG10LOG10(n)

Returns the base-10 logarithm.

RANDRAND([seed])

Returns a random floating-point value between 0 and 1.

SIGNSIGN(n)

Returns 1, 0, or -1 for positive, zero, or negative.

PIPI()

Returns the value of pi.

DEGREESDEGREES(n)

Converts radians to degrees.

RADIANSRADIANS(n)

Converts degrees to radians.

SINSIN(n)

Returns the sine value.

COSCOS(n)

Returns the cosine value.

TANTAN(n)

Returns the tangent value.

ATN2ATN2(y, x)

Returns the arctangent of two coordinates.