I think that "UPSERT" and "IF EXISTS" are usefull only when the TicketNumber column is not auto-generated by identity column (as all best practices suggest).

With identity column, you are inserting when parm3 is undefined, updating when parm3 is defined. So I can't see a way to apply an UPSERT in the most applied scenario.

Is there a way to apply usefully an UPSERT when the table has an identity column?

Thanks for attention and for your interesting article

Alessio Bellisomi