POWER returns a number (input_x) raised to the power of a number (input_y). : Power « Math Functions « SQL Server / T-SQL Tutorial






  1. SQL Server / T-SQL Tutorial
  2. Math Functions
  3. Power
4>
5>
6> SELECT 1464*(1/POWER((1+.10),4))
7> GO

----------------------------------------
     1002.739726027397260273972602739726

(1 rows affected)
1>








11.15.Power
11.15.1.POWER returns a number (input_x) raised to the power of a number (input_y).
11.15.2.SELECT POWER(10,2) Result