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)

Updated: 14 April 2006

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

Topic link icon Transact-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)

Release History

14 April 2006

Changed content:
  • Changed numeric_expression argument to float_expression in the syntax and the related argument description.

Community Additions

ADD
Show:
© 2015 Microsoft