Chapter 2: Transact-SQL Functions

sqrt

Returns the square root of the specified number.

sqrt(approx_numeric)

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.
```
For general information about mathematical functions, see “Mathematical functions”.

ANSI SQL – Compliance level: Transact-SQL extension.

Any user can execute sqrt.