SQRT and SQUARE Functions in SQL Server

dbtut March 7, 2019 MSSQL, TSQL

SQRT function returns the square root of a float value and the return data type is float.

SQUARE function returns the square of a float value ant the return data type is float.

Look at the example below;

SQRT Function:

SELECT SQRT(1),
       SQRT(4),
       SQRT(9),
       SQRT(12),
       SQRT(12.3)

SELECT SQRT(1),

SQRT(4),

SQRT(9),

SQRT(12),

SQRT(12.3)

SQUARE Function:

SELECT SQUARE(1),
       SQUARE(4),
       SQUARE(9),
       SQUARE(12),
       SQUARE(12.3)

SELECT SQUARE(1),

SQUARE(4),

SQUARE(9),

SQUARE(12),

SQUARE(12.3)

Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux