EXP

Example

Calculate and return the value of $e$ raised to the power of 1.

SELECT EXP(1);

Definition and Usage

The EXP() function calculates the value of $e$ raised to the power of a given number, where $e$ (approximately 2.718281…) is the base of natural logarithms.

Note: Also refer to the LOG() function for logarithmic operations.

Syntax

EXP(number)

Parameter Values

Parameter	Description
number	Required: The exponent value.

Technical Details

Works in:

Available in SQL Server from 2008 onward, as well as in Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse.

More Examples

Example

Calculate and return the value of $e$ raised to the power of 2.

SELECT EXP(2);