The rules for specifying deterministic and nondeterministic functions in a MERGE statement ON clause differ for primary and secondary conditions.
The section describes restrictions for specifying deterministic and nondeterministic functions in the primary condition of an ON clause.