##### Asked by: Svyatoslav Verhaegen

asked in category: General Last Updated: 10th January, 2020# What does deterministic mean in SQL?

**SQL**Server are either

**deterministic**or nondeterministic. A function is considered

**deterministic**if it always returns the same result set when it's called with the same set of input values.

Click to see full answer .

Beside this, what is deterministic SQL?

Overview. ** SQL ** functions in SQLite can be either " ** deterministic ** " or "non- ** deterministic ** ". A ** deterministic ** function always gives the same answer when it has the same inputs. For example, the abs(X) function always returns the same answer as long as its input X is the same.

Additionally, what is deterministic and nondeterministic function in SQL Server? ** Functions ** can be either ** deterministic ** or ** nondeterministic ** . A ** deterministic function ** always returns the same results if given the same input values. A ** nondeterministic function ** may return different results every time it is called, even when the same input values are provided.

Besides, what is a deterministic statement?

** DETERMINISTIC ** Functions. The ** DETERMINISTIC ** clause for functions is ideal for functions that do not have any non- ** deterministic ** components. This means that each time you provide the function with the same parameter values, the result is the same. Function-based indexes can only use functions marked ** DETERMINISTIC ** .

What is the difference between deterministic and nondeterministic?

In ** deterministic ** algorithm, for a given particular input, the computer will always produce the same output going through the same states but in case of ** non-deterministic ** algorithm, for the same input, the compiler may produce ** different ** output in ** different ** runs.