SQL Server/T-SQL Tutorial/Math Functions/SQRT

SELECT SQRT(100) Result

   <source lang="sql">

3> 4> SELECT SQRT(100) Result 5> GO Result

---

                     10

(1 rows affected)</source>

select SQRT(125.43)

   <source lang="sql">

3> select SQRT(125.43) 4> GO

---

     11.199553562530964

(1 rows affected)</source>

SQRT function returns the square root of a value 0 or greater.

   <source lang="sql">

The syntax of SQRT is as follows: SQRT(input_number) 6> 7></source>