Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

POWER (Transact-SQL)

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

Topic link iconTransact-SQL Syntax Conventions


POWER (float_expression , y )

float_expression

Is an expression of type float or of a type that can be implicitly converted to float.

y

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

Same as float_expression.

A. Using POWER to show results of 0.0

The following 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. Using POWER

The following example returns POWER results for 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)

Community Additions

ADD
Show:
© 2015 Microsoft