SQL SQUARE Function

The SQL SQUARE Function is a SQL Mathematical Function that is used to calculate the square of the specified expression or number. The syntax of the SQL Server SQUARE Function is

SELECT SQUARE (Float_Expression)
FROM [Source]

For this Sql Server SQUARE Function demo, we use the below-shown data

SQL SQUARE Function Example 1

The SQUARE Function calculates the square of a given numeric value. The following query will show multiple ways to use the SQUARE function.

DECLARE @i float = 2, @j int = 2.20

SELECT SQUARE(@i) AS [SQL SQUARES]

-- Calculating SQUARE directly
SELECT SQUARE(3.20) AS [SQL SQUARES]

-- Wrong Value
SELECT SQUARE(@j) AS [SQL SQUARE]
SELECT SQUARE(2.20) AS [SQL SQUARE]

OUTPUT

ANALYSIS

We used the SQUARE function to calculate the square of the variable @i, and assigned a new name using the ALIAS Column.

SELECT SQUARE(@i) AS [SQL SQUARES]

It means,

@i * @i = 2 * 2 = 4

In the next statement, We used the integer value as input for the SQUARE function.

-- Wrong Value
SELECT SQUARE(@j) AS [SQL SQUARES]
SELECT SQUARE(2.20) AS [SQL SQUARES]

It means

SQUARE (@j) = @j * @j

= 2.20 * 2.20 = 4.84

But we are getting 4 as a result because it is rounding the 2.20 value to 2

NOTE: Please use float variables as an input for SQUARE Function; otherwise, you may expect strange results.

SQUARE Function Example 2

Square Function also allows you to calculate the square of column values. In this example, we will calculate the square of All the records present in [Sales Amount] using SQUARE Function.

SELECT [EnglishProductName]
      ,[Color]
      ,[StandardCost]
      ,[SalesAmount]
      ,SQUARE([SalesAmount]) AS Sales
 FROM [Mathemetical Functions]

OUTPUT