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 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 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.