SQUARE (SSIS)
Returns the square of a numeric expression.
Syntax
SQUARE(numeric_expression)
Arguments
- numeric_expression
Is a numeric expression of any numeric data type. For more information, see Integration Services Data Types.
Result Types
DT_R8
Remarks
SQUARE returns a null result if the argument is null.
The argument is cast to the DT_R8 data type before the square operation.
Examples
This example returns the square of 12. The return result is 144.
SQUARE(12)
This example returns the square of the result of subtracting values in two columns. If Value1 contains 12 and Value2 contains 4, the SQUARE function returns 64.
SQUARE(Value1 - Value2)
This example returns the length of the third side of a right angle triangle by applying the SQUARE function to two variables and then calculating the square root of their sum. If Side1 contains 3 and Side2 contains 4, the SQRT function returns 5.
SQRT(SQUARE(@Side1) + SQUARE(@Side2))
Note
In expressions, variable names always include the @ prefix.