.png)
SQRT (Transact-SQL)
SQL Server 2005
Returns the square root of the specified float value.
Transact-SQL Syntax Conventions
- float_expression
-
Is an expression of type float or of a type that can be implicitly converted to float.
The following example returns the square root of numbers between 1.00 and 10.00.
DECLARE @myvalue float;
SET @myvalue = 1.00;
WHILE @myvalue < 10.00
BEGIN
SELECT SQRT(@myvalue);
SET @myvalue = @myvalue + 1
END;
GO
Here is the result set.
------------------------ 1.0 ------------------------ 1.4142135623731 ------------------------ 1.73205080756888 ------------------------ 2.0 ------------------------ 2.23606797749979 ------------------------ 2.44948974278318 ------------------------ 2.64575131106459 ------------------------ 2.82842712474619 ------------------------ 3.0
