Constants and randomness

Description

DEGREES

Converts radians to degrees.

RADIANS

Converts degrees to radians.

This category includes functions that scale values exponentially, compute logarithmic

magnitude, raise numbers to arbitrary powers, or extract roots. Typical workloads include

financial compounding, scoring models, machine-learning feature engineering, scientific

analysis, and any transformation involving nonlinear growth or decay.

Description

EXP

Exponential value of the expression (e raised to the expression).

LOG

Natural logarithm by default; optional base supported in SQL Server.

LOG10

Base-10 logarithm.

POWER

Raises the expression to the specified power.

SQRT

Square root of the specified value.

SQUARE

Square of the specified value.

sampling, stochastic modeling, testing, and procedural computations. Use them for simulation,

seeded.

Description

PI

Returns the constant

(pi).

RAND

Returns a pseudo-random float between 0 and 1.

Expand table

Expand table

Expand table

π