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 Mathematical Function 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]

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 from SQL.
SQUARE Function Example 2
The 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]
