MERGE Syntax - SQL Server 2008 Transact-SQL Recipes
I received an email about this today (Thanks again Steven) and thought I would put out a brief post on this topic just to share with others...
A couple of months before SQL Server 2008 Transact-SQL Recipes was sent to the printer, pre-RTM, there were a few key syntax changes made to various commands and stored procedure calls/parameters. I spent a couple of days revising my code and then forwarding to the editors. Even though this was a couple of months before printing, and even though I had assurances that my changes would be made, I found that a couple of items from Chapter 2 were not fixed. Specifically, the MERGE command uses the pre-RTM syntax.
To make up for this, Apress made Chapter 2 (in the fixed form) a free downloadable chapter, which you can get on the link below:
Ch. 02 - Perform, Capture, and Track Data Modifications (Corrected Version of Chapter 2)
I found this issue when I received the printed form of my book. I was so excited when it arrived, and then I immediately found they had not corrected this. It was kind of like getting that first scratch or dent on a new car. Anyhow, thought I would call out the chapter and let readers know again. I posted about this on the old blog a few months ago, but it bears repeating.
Thanks for reading!