SQL SQUARE Function

 The SQL SQUARE Function is one of the SQL 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 2014 is as shown below:

In this article we will show you, How to write SQUARE Function in SQL Server 2014 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

OUTPUT

Analysis

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

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 SQL ALIAS Column.

It means,

@i * @i  = 2 * 2  = 4

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

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

OUTPUT

Thank You for Visiting Our Blog