SQL Server SQUARE() Function

Summary: in this tutorial, you will learn how to use the SQL Server SQUARE() function to calculate the square of a number.

Introduction to the SQL Server SQUARE() function #

The SQUARE() function is a mathematical function that allows you to calculate the square of a number.

Here’s the syntax of the SQUARE() function:

SQRT(number)Code language: SQL (Structured Query Language) (sql)

In this syntax:

The number is a float or any number that can be implicitly converted to a float.

The SQUARE() function returns the square of the number with the type of float. If the number is NULL, the SQUARE() function returns NULL.

SQL Server SQUARE() function examples #

Let’s explore some examples of using the SQUARE() function.

1) Basic SQUARE() function example #

The following statement uses the SQUARE() function to return the square of 5:

SELECT SQUARE(5) AS result;Code language: SQL (Structured Query Language) (sql)

Result:

result
------
25Code language: SQL (Structured Query Language) (sql)

The query returns 25 as the square of 5.

2) Using the SQUARE() function to calculate areas of squares #

First, create a table called squares to store the length of squares:

CREATE TABLE squares(
    id INT IDENTITY PRIMARY KEY,
    length DEC(10,2)
);Code language: SQL (Structured Query Language) (sql)

Second, insert some rows into the squares table:

INSERT INTO squares (length) 
VALUES
    (2.5),
    (3),
    (5),
    (6),
    (9);Code language: SQL (Structured Query Language) (sql)

Third, retrieve data from the squares table:

SELECT
  id,
  length
FROM
  squares;Code language: SQL (Structured Query Language) (sql)

Output:

id | length
---+---------
1  | 2.50
2  | 3.00
3  | 5.00
4  | 6.00
5  | 9.00
(5 rows)Code language: plaintext (plaintext)

Finally, calculate the areas of the squares using the SQUARE() function:

SELECT
  id,
  length,
  SQUARE(length) area
FROM
  squares;Code language: SQL (Structured Query Language) (sql)

Output:

id | length | area
---+--------+-------
1  | 2.50   | 6.25
2  | 3.00   | 9.0
3  | 5.00   | 25.0
4  | 6.00   | 36.0
5  | 9.00   | 81.0
(5 rows)Code language: plaintext (plaintext)

Summary #

Use the SQL Server SQUARE() function to calculate the square of a number.

Was this tutorial helpful?