Export (0) Print
Expand All

SQRT

SQL Server 2000

Returns the square root of the given expression.

Syntax
SQRT ( float_expression ) 
Arguments
float_expression
Is an expression whose type can be implicitly converted to float.
Return Types

float

Examples

The following example returns the square root of the freight charges from the Orders table in the Northwind database.

SELECT Freight, SQRT(Freight) AS "Square root of Freight"
FROM Orders

Show:
© 2014 Microsoft