Select from following answers:- BUILT-IN functions in SQL Server are Nondeterministic
- ISNULL function in SQL Server is Deterministic.
- All of the above
- None
- All Above
Deterministic functions always return the same result any time they are called with a specific set of input values and given the same state of the database. Nondeterministic functions may return different results each time they are called with a specific set of input values even if the database state that they access remains the same.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator