Tag: SQL Server Numeric Functions

SQL – SQL Server ABS() Function

August 5, 2024 / Reference, SQL Reference, SQL Server Functions / Number, SQL Server, SQL Server Numeric Functions

The SQL Server ABS() function returns the absolute value of a number.

SQL – SQL Server ACOS() Function

August 5, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

The SQL Server ACOS() function returns the arc cosine of a specified number between -1 and 1.

SQL – SQL Server ASIN() Function

August 5, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

The SQL Server ASIN() function returns the arc sine of a specified number between -1 and 1.

SQL – SQL Server ATAN() Function

August 5, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

The SQL Server ATAN() function returns the arc tangent of a number.

SQL – SQL Server ATN2() Function

August 5, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

The SQL Server ATN2() function returns the arc tangent of two numbers.

SQL – SQL Server AVG() Function

August 5, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

The SQL Server AVG() function returns the average value of an expression (NULL values are ignored).

SQL – SQL Server CEILING() Function

August 5, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

The SQL Server CEILING() function returns the smallest integer value that is larger than or equal to a number.

SQL – SQL Server COS() Function

August 5, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

The SQL Server COS() function returns the cosine of a number.

SQL – SQL Server COT() Function

August 5, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

The SQL Server COT() function returns the cotangent of a number.

SQL – SQL Server COUNT() Function

August 5, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

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

August 6, 2024 / Reference, SQL Reference, SQL Server Functions / SQL Server, SQL Server Numeric Functions

The SQL Server DEGREES() function converts a value in radians to degrees.

SQL – SQL Server EXP() Function

August 6, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

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

August 6, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

The SQL Server FLOOR() function returns the largest integer value that is smaller than or equal to a number.

SQL – SQL Server LOG() Function

August 7, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

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

August 7, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

The SQL Server LOG10() function returns the natural logarithm of a number greater than 0 to base 10.

SQL – SQL Server MAX() Function

August 7, 2024 / Reference, SQL Reference, SQL Server Functions / SQL Server, SQL Server Numeric Functions

The SQL Server MAX() function returns the maximum value in a set of values.

SQL – SQL Server MIN() Function

August 7, 2024 / Reference, SQL Reference, SQL Server Functions / SQL Server, SQL Server Numeric Functions

The SQL Server MIN() function returns the minimum value in a set of values.

SQL – SQL Server PI() Function

August 7, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

The SQL Server PI() function returns the value of PI.

SQL – SQL Server POWER() Function

August 7, 2024 / Reference, SQL Reference, SQL Server Functions / Math, SQL Server, SQL Server Numeric Functions

The SQL Server POWER() function returns the value of a number raised to the power of another number.

SQL – SQL Server RADIANS() Function

August 7, 2024 / Reference, SQL Reference, SQL Server Functions / SQL Server, SQL Server Numeric Functions

The SQL Server RADIANS() function converts a degree value (expressed as a positive or negative number) into radians.