Returns the value that results from raising the specified number to a given power. power, a mathematical function, returns the value of value raised to the power power. Results are of the same type as value.
power(value, power)
select power(2, 3)
----------- 8
In expressions of type numeric or decimal, this function returns precision:38, scale 18.
See also Transact-SQL Users Guide.
ANSI SQL – Compliance level: Transact-SQL extension.
Any user can execute power.