POWER (T-SQL)

Returns the value of the given expression to the specified power.

Syntax

POWER(numeric_expression, y)

Arguments

numeric_expression

Is an expression of the exact numeric or approximate numeric data type category, except for the bit data type.

y

Is the power to which to raise numeric_expression. y can be an expression of the exact numeric or approximate numeric data type category, except for the bit data type.

Return Types

Same as numeric_expression.

Examples

A. Use POWER to show results of 0.0

This example shows a floating point underflow that returns a result of 0.0.

SELECT POWER(2.0, -100.0)

GO

Here is the result set:

------------------------------------------

0.0

(1 row(s) affected)

B. Use POWER

This example returns POWER results for 2¹ to 2⁴.

DECLARE @value int, @counter int

SET @value = 2

SET @counter = 1

WHILE @counter < 5

    BEGIN

        SELECT POWER(@value, @counter)

        SET NOCOUNT ON

        SET @counter = @counter + 1

        SET NOCOUNT OFF

    END

GO

Here is the result set:

-----------

2          

(1 row(s) affected)

-----------

4          

(1 row(s) affected)

-----------

8          

(1 row(s) affected)

-----------

16         

(1 row(s) affected)

See Also