SQRT and SQUARE Functions in SQL Server


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:

SQUARE Function:

Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *