A brief summary of SQL Server math functions

In the previous article, we introduced to you "A brief summary of mysql mathematical functions". Below we continue to briefly organize SQL Server mathematical functions for you.

Transact-SQL contains many mathematical functions that can be used with SQL Server.

The following scalar functions can be used in SQL Server 2012 and later versions. Most of these functions accept one or more arguments and will return a numeric value based on the arguments provided.

ABS()

Returns the absolute (positive) value of the specified numeric expression. In other words, it allows you to determine whether a number is positive, negative, or zero.

ACOS()

Returns the arc cosine. In other words, it returns the angle in radians and the cosine value is the specified floating point expression.

ASIN()

Returns the arc sine. In other words, it returns the angle in radians whose sine is the specified floating point expression.

ATAN()

Returns the arctangent value. In other words, it returns the angle in radians whose tangent is the specified floating point expression.

ATN2()

Returns the angle (in radians) between the positive x-axis and the ray from the origin to point (y, x), where x and y is the value of the two specified float expressions.

CEILING()

Allows you to round a number to the nearest integer. It returns the smallest integer greater than or equal to the specified numeric expression.

COS()

Returns the trigonometric cosine (in radians) of the angle specified in the specified expression.

COT()

Returns the trigonometric cotangent value (expressed in radians) of the specified angle in the specified float value expression.

DEGREES()

Let’s convert from radians to degrees. Specifically, this function returns the corresponding angle in degrees for an angle specified in radians.

EXP()

Returns the exponent value of the specified float expression.

FLOOR()

can be rounded down to the nearest integer. It returns the largest integer less than or equal to the specified numeric expression.

LOG()

Returns the natural logarithm of the specified float expression.

LOG10()

Returns the base 10 logarithm of the specified float expression.

PI()

Returns the constant value of PI.

POWER()

Returns the value of the specified expression to the specified power.

RADIANS()

Allows you to convert degrees to radians. Specifically, it returns radians when a numeric expression (in degrees) is entered.

RAND()

Returns a pseudo-random floating point value from 0 to 1, exclusive.

ROUND()

Returns a numeric value, rounded to the specified length or precision.

SIGN()

Returns the positive (1), zero (0), or negative (-1) sign of the specified expression.

SIN()

Returns the trigonometric sine of the specified angle (in radians) and the approximate numeric floating point expression.

SQRT()

Returns the square root of the specified float value.

SQUARE()

Returns the square of the specified float value.

TAN()

Returns the tangent value of the input expression.

All functions except RAND() are deterministic. This means that they return the same results every time they are called with a specific set of input values. RAND() Only deterministic when subparameters are specified.

Related recommendations: "SQL Tutorial" "MySQL Tutorial"

The above is the detailed content of A brief summary of SQL Server math functions. For more information, please follow other related articles on the PHP Chinese website!