ATN2() Examples in SQL Server

In SQL Server, the ATN2() function returns the arctangent between two values. Specifically, it returns the angle, in radians, between the positive x-axis and the ray from the origin to the point (y, x), where x and y are the values of the two specified float expressions.

You provide the values as arguments when calling the function.

Continue reading

ABS() Examples in SQL Server

In SQL Server, the ABS() function returns the absolute value of a specified value.

You provide the value as an argument. The return value is of the same type as the argument.

An absolute value is the distance of a number on the number line from 0 without considering which direction from zero the number lies. Therefore, the absolute value of a number is always a non-negative value (i.e. it’s never negative).

Continue reading