SQL Server SQRT() Function

The SQRT() function in SQL Server calculates the square root of a number. The square root of a number is a value that, when multiplied by itself, equals the original number.

SQRT(): Definition and Usage

The SQRT() function is a fundamental mathematical function used in various calculations, particularly in areas like geometry, statistics, or any other domain where square roots are required. The input must be a non-negative number (zero or a positive number); otherwise, an error will occur.

Syntax

SQRT(number)
      

Parameter Values

Examples

Calculating the Square Root of a Perfect Square

This example calculates the square root of 64 (which is 8 because 8 * 8 = 64).

SELECT SQRT(64);
      

8.000000
      

Calculating the Square Root of a Non-Perfect Square

This example calculates the square root of 13, which is an irrational number (a number that cannot be expressed as a simple fraction).

SELECT SQRT(13);
      

3.60555127546399