# Mathematical Functions (Transact-SQL)

**APPLIES TO:** SQL Server Azure SQL Database Azure Synapse Analytics (SQL DW) Parallel 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.

## See Also

Arithmetic Operators (Transact-SQL)

Built-in Functions (Transact-SQL)

## Feedback

Loading feedback...