SQL Server POWER() Function

Return 4 raised to the second power:

SELECT POWER(4, 2);

Definition and Usage

The POWER() function returns the value of a number raised to the power of another number.

POWER( a, b)

Parameter	Description
a	Required. A number (the base)
b	Required. A number (the exponent)

Works in:	SQL Server (starting with 2008), Azure SQL Database, Azure SQL Data Warehouse, Parallel Data Warehouse

Return 8 raised to the third power:

SELECT POWER(8, 3);