Calculates the square root of the specified number.
Syntax
sqrt(approx_numeric)
Parameters
- approx_numeric – is any approximate numeric (float, real, or double
precision) column name, variable, or constant expression
that evaluates to a positive number.
Examples
- Example 1 – Calculates the square root of 4:
select sqrt(4)
Usage
If you attempt to select the square root of a negative number,
the SAP ASE server returns an error message similar to:
Domain error occurred.
See also Transact-SQL Users Guide.
Standards
ANSI SQL – Compliance level: Transact-SQL
extension.
Permissions
Any user can execute sqrt.