SQL - Power

POWER( base, exponent )

SELECT POWER(2,3) ;

Example 1

DECLARE @input1 float; 

DECLARE @input2 float; 

SET @input1= 2; 

SET @input2 = 2.5; 

SELECT POWER(@input1, 3) AS Result1, POWER(@input2, 3) AS Result2; 


Example 2

SELECT  

POWER(CAST(2.0 AS float), -100.0) AS FloatResult, 

POWER(2, -100.0) AS IntegerResult, 

POWER(CAST(2.0 AS int), -100.0) AS IntegerResult, 

POWER(2.0, -100.0) AS Decimal1Result, 

POWER(2.00, -100.0) AS Decimal2Result, 

POWER(CAST(2.0 AS decimal(5,2)), -100.0) AS Decimal2Result; 

Example 3

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