Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Returns the result of raising a numeric expression to a power. The power parameter must evaluate to an integer.
Syntax
POWER(numeric_expression,power)
Arguments
numeric_expression
Is a valid numeric expression.
power
Is a valid numeric expression.
Result Types
DT_R8
Remarks
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.
Expression Examples
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)