All expressions and functions are either deterministic or nondeterministic:
Deterministic expressions and functions always return the same result, if they are evaluated with the same set of input values.
Non-deterministic expressions of functions may return different results each time they are evaluated, even when they are called with the same set of input values.
“Deterministic property” is a property of the expression that defines a computed column or a function-based index key, and thus defines the computed column or function-based index key itself.
This expression is deterministic:
c1 * c2
The function getdate is nondeterministic, because it always returns the current date.
