Every day for the next couple of weeks, I aim to highlight one of SQL Server 2008’s new features, simply for awareness. You can then go away and research the area and report back to me, we’ll then discuss how these new features can benefit us all.
Friday 4th June 2010
Merge SQL Statement
Finally ! They’ve created a MERGE SQL Statement.
Allowing us to handle common data warehousing scenarios, like checking whether a row exists, and then executing an insert or update, more effectively.