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, CONVERT
Non deterministic functions - GETDATE, RAND, @@ROWCOUNT. USER_NAME, IDENTITY
Asked In: WIPRO |