Export (0) Print
Expand All

Mathematical Functions (Transact-SQL)

 

Applies To: SQL Server 2014, SQL Server 2016 Preview

The following scalar functions perform a calculation, usually based on input values that are provided as arguments, and return a numeric value:

ABS           

DEGREES           

RAND           

ACOS           

EXP           

ROUND           

ASIN           

FLOOR           

SIGN           

ATAN           

LOG           

SIN           

ATN2           

LOG10           

SQRT           

CEILING           

PI           

SQUARE

COS           

POWER           

TAN           

COT           

RADIANS           

 

System_CAPS_noteNote

Arithmetic functions, such as ABS, CEILING, DEGREES, FLOOR, POWER, RADIANS, and SIGN, return a value having the same data type as the input value. Trigonometric and other functions, including EXP, LOG, LOG10, SQUARE, and SQRT, cast their input values to float and return a float value.

All mathematical functions, except for RAND, are deterministic functions. This means they return the same results each time they are called with a specific set of input values. RAND is deterministic only when a seed parameter is specified. For more information about function determinism, see Deterministic and Nondeterministic Functions.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft