Mathematical Functions (Transact-SQL) [!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw] The following scalar functions perform a calculation, usually based on input values that are provided as ...

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.