This table shows the equivalent Microsoft® SQL Server™ function for each Oracle function.
| Function | Oracle | SQL Server |
|---|---|---|
| Absolute value | ABS | ABS |
| Arc cosine | ACOS | ACOS |
| Arc sine | ASIN | ASIN |
| Arc tangent of n | ATAN | ATAN |
| Arc tangent of n and m | ATAN2 | ATN2 |
| Smallest integer >= value | CEIL | CEILING |
| Cosine | COS | COS |
| Hyperbolic cosine | COSH | COT |
| Exponential value | EXP | EXP |
| Largest integer <= value | FLOOR | FLOOR |
| Natural logarithm (base 2) | LOG(2, n) | LOG(n) |
| Logarithm, base 10 | LOG(10, n) | LOG10(n) |
| Logarithm, other base | LOG(m, n) | N/A |
| Modulus (remainder) | MOD | % (modulus operator) |
| Power | POWER | POWER |
| Round | ROUND | ROUND |
| Sign of number | SIGN | SIGN |
| Sine | SIN | SIN |
| Hyperbolic sine | SINH | N/A |
| Square root | SQRT | SQRT |
| Tangent | TAN | TAN |
| Hyperbolic tangent | TANH | N/A |
| Truncate | TRUNC | N/A |
| Largest number in list | GREATEST | N/A |
| Smallest number in list | LEAST | N/A |
| Convert number if NULL | NVL | ISNULL |