This is a quick reference list of SQL Server numeric functions and how they are used to work with databases.

• SQL – SQL Server ABS() Function
  The SQL Server ABS() function returns the absolute value of a number.
• SQL – SQL Server ACOS() Function
  The SQL Server ACOS() function returns the arc cosine of a specified number between -1 and 1.
• SQL – SQL Server ASIN() Function
  The SQL Server ASIN() function returns the arc sine of a specified number between -1 and 1.
• SQL – SQL Server ATAN() Function
  The SQL Server ATAN() function returns the arc tangent of a number.
• SQL – SQL Server ATN2() Function
  The SQL Server ATN2() function returns the arc tangent of two numbers.
• SQL – SQL Server AVG() Function
  The SQL Server AVG() function returns the average value of an expression (NULL values are ignored).
• SQL – SQL Server CEILING() Function
  The SQL Server CEILING() function returns the smallest integer value that is larger than or equal to a number.
• SQL – SQL Server COS() Function
  The SQL Server COS() function returns the cosine of a number.
• SQL – SQL Server COT() Function
  The SQL Server COT() function returns the cotangent of a number.
• SQL – SQL Server COUNT() Function
  The SQL Server COUNT() function returns the number of records returned by a select query. NULL values are not counted.
• SQL – SQL Server DEGREES() Function
  The SQL Server DEGREES() function converts a value in radians to degrees.
• SQL – SQL Server EXP() Function
  The SQL Server EXP() function returns the natural logarithm e (2.718281…) raised to the power of the specified number.
• SQL – SQL Server FLOOR() Function
  The SQL Server FLOOR() function returns the largest integer value that is smaller than or equal to a number.
• SQL – SQL Server LOG() Function
  The SQL Server LOG() function returns the natural logarithm of a specified number, or the logarithm of the number to the specified base.
• SQL – SQL Server LOG10() Function
  The SQL Server LOG10() function returns the natural logarithm of a number greater than 0 to base 10.
• SQL – SQL Server MAX() Function
  The SQL Server MAX() function returns the maximum value in a set of values.
• SQL – SQL Server MIN() Function
  The SQL Server MIN() function returns the minimum value in a set of values.
• SQL – SQL Server PI() Function
  The SQL Server PI() function returns the value of PI.
• SQL – SQL Server POWER() Function
  The SQL Server POWER() function returns the value of a number raised to the power of another number.
• SQL – SQL Server RADIANS() Function
  The SQL Server RADIANS() function converts a degree value (expressed as a positive or negative number) into radians.
• SQL – SQL Server RAND() Function
  The SQL Server RAND() function returns a random number between 0 (inclusive) and 1 (exclusive).
• SQL – SQL Server ROUND() Function
  The SQL Server ROUND() function rounds a number to a specified number of decimal places.
• SQL – SQL Server SIGN() Function
  The SQL Server SIGN() function returns the sign of a number.
• SQL – SQL Server SIN() Function
  The SQL Server SIN() function returns the sine of a number.
• SQL – SQL Server SQRT() Function
  The SQL Server SQRT() function returns the square root of a positive number.
• SQL – SQL Server SQUARE() Function
  The SQL Server SQUARE() function returns the square of a number (the number times itself).
• SQL – SQL Server SUM() Function
  The SQL Server SUM() function calculates the sum of a set of values. NULL values are ignored.
• SQL – SQL Server TAN() Function
  The SQL Server TAN() function returns the tangent of a number.