MySafeInfo

SQL Server Math/Numeric Functions

Technology 28 records updated 2026-07-17

SQL Server Math/Numeric Functions, with function, and description.

Get this data

GET https://mysafeinfo.com/api/data/sqlservermathnumericfunctions

JSON XML CSV Download CSV

Sort, page, randomize, and download with query parameters; see the documentation.

Try it live

Run a request against sqlservermathnumericfunctions straight from your browser. Add your API key to lift the row cap and return every record. The call goes to the API and nothing is stored here.

Preview

First 25 of 28 records. Click a column to sort these rows.

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
11 DEGREES Converts a value in radians to degrees
12 EXP Returns e raised to the power of a specified number
13 FLOOR Returns the largest integer value that is <= to a number
14 LOG Returns the natural logarithm of a number, or the logarithm of a number to a specified base
15 LOG10 Returns the natural logarithm of a number to base 10
16 MAX Returns the maximum value in a set of values
17 MIN Returns the minimum value in a set of values
18 PI Returns the value of PI
19 POWER Returns the value of a number raised to the power of another number
20 RADIANS Converts a degree value into radians
21 RAND Returns a random number
22 ROUND Rounds a number to a specified number of decimal places
23 SIGN Returns the sign of a number
24 SIN Returns the sine of a number
25 SQRT Returns the square root of a number

Notes