You need to determine whether a function named fnTest from the sales schema is deterministic. Which code can you use?

You need to determine whether a function named fnTest from the sales schema is deterministic. Which code can you use?

You need to determine whether a function named fnTest from the sales schema is deterministic. Which code can you use?


Answer: – SELECT OBJECTPROPERTY (OBJECT_ID (‘sales.fnTest’), ‘IsDeterministic’);
GO

(The OBJECTPROPERTY function with the ObjectID of the function and IsDeterministric as arguments comprise the solution.)