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.
In expressions of type numeric or decimal, this function returns precision:38, scale 18.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute power.
For general information about mathematical functions, see “Mathematical functions”.
