Using SQL Server, you can use the T-SQL SQRT() function to return the square root of a specified float value.
You provide the number as an argument when calling the function.
The return data type is float.
Tag: mssql
SIN() Examples in SQL Server
Using SQL Server, you can use the T-SQL SIN() function to return the sine of a number. More specifically, this function returns the trigonometric sine of the specified angle, in radians, and in an approximate numeric, float, expression.
The return data type is float.
You provide the number as an argument when calling the function.
SIGN() Examples in SQL Server
In SQL Server, the T-SQL SIGN() function returns the sign of a number. In other words, it indicates whether or not the value is a positive number, a negative number, or zero.
You provide the number as an argument when calling the function.
The function returns the following result, depending on whether the argument is positive, negative, or zero.
- 1 if the number is positive
- -1 if the number is negative
- 0 if the number is zero
ROUND() Examples in SQL Server
In SQL Server, the T-SQL ROUND() function allows you to round a number to a specified length or precision.
You provide the number as an argument, as well as the length you’d like the number to be rounded to. The function also accepts an optional third argument that allows you to specify whether the number is rounded or truncated.
RAND() Examples in SQL Server
In SQL Server, the T-SQL RAND() function allows you to generate a random number. Specifically, it returns a pseudo-random float value from 0 through 1, exclusive.
The function accepts an optional argument which provides the seed value. For any given seed value, the results will always be the same.
RADIANS() Examples in SQL Server
In SQL Server, the T-SQL RADIANS() function converts a value from degrees to radians, and returns the result.
You provide the angle (specified in degrees) as an argument when calling the function, and the function will return that angle in radians.
The return value is uses the same data type as the argument.
DEGREES() Examples in SQL Server
In SQL Server, the T-SQL DEGREES() function converts a value from radians to degrees, and returns the result.
You provide the angle (specified in radians) as an argument when calling the function, and the function will return that angle in degrees.
The return value is of a data type that matches the argument.
POWER() Examples in SQL Server
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.
LOG10() Examples in SQL Server
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.
LOG() Examples in SQL Server
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.