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.
Non deterministic 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.
Deterministic functions - SUM, AVG, DAY, ISNUMERIC, ISNULL
Non deterministic functions - GETDATE, RAND, @@ROWCOUNT. USER_NAME, IDENTITY
Non deterministic 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.
Deterministic functions - SUM, AVG, DAY, ISNUMERIC, ISNULL
Non deterministic functions - GETDATE, RAND, @@ROWCOUNT. USER_NAME, IDENTITY
No comments:
Post a Comment