sqrt

Description

Returns 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

select sqrt(4)
 2.000000

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute sqrt.

See also

Functions power