power

Description

Returns the value that results from raising the specified number to a given power.

Syntax

power(value, power)

Parameters

value

is a numeric value.

power

is an exact numeric, approximate numeric, or money value.

Examples

Example 1

select power(2, 3)
-----------
         8 

Usage

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute power.

See also

For general information about mathematical functions, see “Mathematical functions”.

Functions exp, log, log10