SQL Server Math/Numeric Functions
SQL Server mathematical and numeric functions and descriptions of their uses.
Download optionsThe records
10 of 28 records ยท Select a column heading to sort.
| ID | Function | Description |
|---|---|---|
| 1 | ABS | Returns the absolute value of a number |
| 2 | ACOS | Returns the arc cosine of a number |
| 3 | ASIN | Returns the arc sine of a number |
| 4 | ATAN | Returns the arc tangent of a number |
| 5 | ATN2 | Returns the arc tangent of two numbers |
| 6 | AVG | Returns the average value of an expression |
| 7 | CEILING | Returns the smallest integer value that is >= a number |
| 8 | COUNT | Returns the number of records returned by a select query |
| 9 | COS | Returns the cosine of a number |
| 10 | COT | Returns the cotangent of a number |
Free sample files (up to 10 rows): CSV JSON XML
Scope and sources
Last checked against sources: October 15, 2026.
Last changed: July 17, 2026. This may reflect a change to the data or its description; it is not a coverage-through date.
A complete download includes all 28 records currently held in this dataset. Check the description and sources to decide whether its scope fits your project.
Use this dataset through the API
GET https://mysafeinfo.com/api/data/sqlservermathnumericfunctionsChoose a format, sort, or request fewer rows. A pass key gives access to the complete dataset. See the examples and parameters.
Without a pass, sorting and randomization apply only to the fixed 10-row sample.