Napomena
Za pristup ovoj stranici potrebna je autorizacija. Možete se pokušati prijaviti ili promijeniti direktorije.
Za pristup ovoj stranici potrebna je autorizacija. Možete pokušati promijeniti direktorije.
The POWER function returns the value of the specified numeric expression to the specified power. POWER(2,3) returns 2 to the third power, or the value 8. Negative powers can be specified. Therefore, POWER(2.000, -3) returns 0.125. Notice that the result of POWER(2, -3) is 0. This is because the result is the same data type as the specified numeric expression. Therefore, if the result has three decimal places, the number to raise to a specific power must have three decimals, too.
The EXP function returns the exponential value in scientific notation of the specific float expression. Therefore, with a value of 198.1938327, the EXP function returns a value of 1.18710159597953e+086, for example:
SELECT EXP(198.1938327)
Here is the result set.
----------------------
1.18710159597953E+86
(1 row(s) affected)
See Also
Other Resources
EXP (Transact-SQL)
POWER (Transact-SQL)
Mathematical Functions (Transact-SQL)