Returns the square root of the specified number.
sqrt(approx_numeric)
is any approximate numeric (float, real, or double precision) column name, variable, or constant expression that evaluates to a positive number.
select sqrt(4)
2.000000
sqrt, a mathematical function, returns the square root of the specified value.
If you attempt to select the square root of a negative number, Adaptive Server returns the following error message:
Domain error occurred.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute sqrt.
For general information about mathematical functions, see “Mathematical functions”.
Function power
