Professional SQL Server™ 2005 Programming

A.5. Mathematical Functions

The mathematical functions perform calculations. They are:

• ABS

• ACOS

• ASIN

• ATAN

• ATN2

• CEILING

• COS

• COT

• DEGREES

• EXP

• FLOOR

• LOG

• LOG10

• PI

• POWER

• RADIANS

• RAND

• ROUND

• SIGN

• SIN

• SQRT

• SQUARE

• TAN

A.5.1. ABS

The ABS function returns the positive, absolute value of numeric expression. The syntax is as follows:

ABS(<numeric expression>)

A.5.2. ACOS

The ACOS function returns the angle in radians for which the cosine is the expression (in other words, it returns the arccosine of expression). The syntax is as follows:

ACOS(<expression>)

The value of expression must be between −1 and 1 and be of the float data type.

A.5.3. ASIN

The ASIN function returns the angle in radians for which the sine is the expression (in other words, it returns the arcsine of expression). The syntax is as follows:

ASIN(<expression>)

The value of expression must be between −1 and 1 and be of the float data type.

A.5.4. ATAN

The ATAN function returns the angle in radians for which the tangent is expression (in other words, it returns the arctangent of expression). The syntax is as follows:

ATAN(<expression>)

The expression must be of the float data type.

A.5.5. ATN2

The ATN2 function returns the angle in radians for which the tangent is between the two expressions provided (in other words, it returns the arctangent of the two expressions). The syntax is as follows:

ATN2(<expression1>, <expression2>)

Both expression1 and expression2 must be of the float data type.

A.5.6. CEILING

The CEILING function returns the smallest ...