| title | POWER (SSIS Expression) | |
|---|---|---|
| description | POWER (SSIS Expression) | |
| author | chugugrace | |
| ms.author | chugu | |
| ms.date | 03/01/2017 | |
| ms.service | sql | |
| ms.subservice | integration-services | |
| ms.topic | reference | |
| helpviewer_keywords |
|
[!INCLUDEsqlserver-ssis]
Returns the result of raising a numeric expression to a power. The power parameter must evaluate to an integer.
POWER(numeric_expression,power)
numeric_expression
Is a valid numeric expression.
power
Is a valid numeric expression.
DT_R8
The numeric_expression and power arguments are cast to the DT_R8 data type before the power is computed. For more information, see Integration Services Data Types.
If numeric_expression evaluates to zero and power is negative, the expression evaluator returns an error and sets the return result to null.
If numeric_expression or power evaluate to indeterminate results, the return result is null.
The power argument can be a fraction. For example, you can use the value 0.5 as the power.
This example uses a numeric literal. The function raises 4 to the power of 3 and returns 64.
POWER(4,3)
This example uses the Length column and the DimensionCount variable. If Length is 8, and DimensionCount is 2, the return result is 64.
POWER(Length, @DimensionCount)