Hi Cooper,

Ok, let me explain why the first example is not deterministic. As per BOL, given four criteria should be met in order to mark the function as deterministic. My first example violates the first criteria that is function is schema-bound.

Further, Why can't I create the function with SCHEMABINDING? Because I have not used two-part names and this function reference itself.

mcp mcse mcsd mcdba