Returns the value that results from raising the specified number to a given power.
power(value, power)
is a numeric value.
is an exact numeric, approximate numeric, or money value.
select power(2, 3)
----------- 8
power, a mathematical function, returns the value of value raised to the power power. Results are of the same type as value.
For expressions of type numeric or decimal, the results have an internal precision of 77 and a scale equal to that of the expression.
For general information about mathematical functions, see “Mathematical functions”.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute power.
