ERROR
Raises an error with an error message.
Archive
DATATABLE
Provides a mechanism for declaring an inline set of data values.
CONVERT
Converts an expression of one data type to another.
TRUNC
Truncates a number to an integer by removing the decimal, or fractional, part of the number.
SUMX
Returns the sum of an expression evaluated for each row in a table.
SUM
Adds all the numbers in a column.
SQRT
Returns the square root of a number.
SIGN
Determines the sign of a number, the result of a calculation, or a value in a column. The function returns 1 if the number is positive, 0 (zero) if the number is zero, or -1 if the number is negative.
ROUNDUP
Rounds a number up, away from 0 (zero).
ROUNDDOWN
Rounds a number down, toward zero.