Roy Ernest (1/11/2012)
With MERGE that was introduced in SQL 2008, this article is actually obsolete unfortunately. But I am glad you read the article.The issue with inserting first is that, you have to catch the PK error to find out if it should do an update. That would mean you will be doing an update on the table in the CATCH part of your code.
Hi Roy - yes I've done the insert first/update second process several times in Oracle (dead easy).
I don't ever remember needing it in SQL Server.
Paul, UK.