Mathematical Functions (Transact-SQL)

 

APPLIES TO: Mathematical Functions (Transact-SQL)_sedSQL Server Mathematical Functions (Transact-SQL)_scala_02Azure SQL Database Mathematical Functions (Transact-SQL)_scala_02Azure SQL Data Warehouse Mathematical Functions (Transact-SQL)_scala_02Parallel Data Warehouse

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​​

 

 Note

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​​.