The SQL SQUARE Function is one of the Mathematical Function which is used to calculate the square of the specified expression or number.

## SQL SQUARE Function Syntax

The basic syntax of the SQUARE Function in SQL Server is as shown below:

SELECT SQUARE (Float_Expression) FROM [Source]

In this article we will show you, How to write SQUARE Function in SQL Server with example. For this, We are going to use the below shown data

## SQL SQUARE Function Example 1

The SQUARE() Function in SQL is used to calculate the square of a given numeric value. The following query will show multiple ways to use SQUARE function.

**T-SQL CODE**

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**

Below lines of code is used to declare float and int variable and assigning the values.

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

In the below statement, We used SQUARE function to calculate the square of the variable @i. We also assigned new name to that result as ‘SQL Squares’ using 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 a input for SQUARE Function otherwise, you may expect strange results.

## SQL SQUARE Function Example 2

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

**T-SQL CODE**

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

**OUTPUT**

Thank You for Visiting Our Blog