Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
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.

Community Additions

ADD
Show:
© 2015 Microsoft