POWER

Description

Returns the value of the specified expression for a specific power. (POWER in Transact-SQL).

Sample Source Pattern

Syntax

POWER( base, exp )

Arguments

base: Base of number, it must be a float expression. exp: Power to which raise the base.

Return Type

The return type depends on the input expression:

Input TypeReturn Type

float, real

float

decimal(p, s)

decimal(38, s)

int, smallint, tinyint

int

bigint

bigint

money, smallmoney

money

bit, char, nchar, varchar, nvarchar

float

Examples

SELECT POWER(2, 3)

Known Issues

No issues were found.

No related EWIs.

Last updated