Quote:
|
Originally Posted by georgev
I'm mainly a Microsoft SQL Server user so my guess is that, as of version 2005, MERGE is the answer?
What about previous versions?
|
MERGE is the answer as from SQL Server 2008. It ought to make the atrocious and flawed UPDATE ... FROM obsolete. True, MERGE has a lousy syntax but it avoids the problems of Microsoft's UPDATE and in many cases MERGE is more efficient than the equivalent UPDATE ... FROM.