In SQL Server, the T-SQL POWER() function is a mathematical function that returns the value of the specified expression to the specified power.
The function accepts two arguments; the first specifies the expression, the second specifies the power with which to raise that expression.
The return value is the same data type as the first argument.
In SQL Server, the T-SQL LOG10() function is a mathematical function that returns the base-10 logarithm of the specified float expression.
You specify the float expression as an argument.
In SQL Server, the T-SQL LOG() function is a mathematical function that returns the natural logarithm of the specified float expression.
You specify the float expression as an argument. You can also provide a second (optional) argument to set the base for the logarithm.
In SQL Server, the T-SQL EXP() function is a mathematical function that returns the exponential value of the specified float expression.
You specify the float expression as an argument.
The exponent of a number is the constant e raised to the power of the number. The constant e (2.718281…), is the base of natural logarithms.
In SQL Server, the T-SQL PI() function is a mathematical function that returns the constant value of π (pi).
In SQL Server, the T-SQL COT() function is a mathematical function that returns the trigonometric cotangent of the specified angle – in radians – in the specified float expression.
You specify the angle by providing an argument to the function when calling it.
In SQL Server, the T-SQL COS() function is a mathematical function that returns the trigonometric cosine of the specified angle – measured in radians – in the specified expression.
You specify the angle by providing an argument to the function when calling it.
In SQL Server, the T-SQL FLOOR() function allows you to round a number down to the nearest integer. More specifically, it returns the largest integer less than or equal to the specified numeric expression.
You provide the number as an argument. The return data type is the same as the one provided as an argument.
In SQL Server, the T-SQL CEILING() function allows you to round a number up to the nearest integer. More specifically, it returns the smallest integer greater than, or equal to, the specified numeric expression.
You provide the number as an argument. The return data type is the same as the one provided as an argument.
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.