Now, I know for most of you, this seems like a rather simple idea. The definition of concatenation is, according to Dictionary.com is : verb (used with object) 1. to link together; unite in a series or chain. Simply put, you combine two or more strings together to form a new string. So, the first … More Concatenation of Strings!
Now, when I last posted, I’m sure you thought I was done talking about the MERGE statement. You are so wrong, compadre! One more post is absolutely needed! There are a few issues with the MERGE statement. Well, as of this writing, there are 361 possible issues according to Microsoft Connect – the actual website … More Merging Data Sources – Part 3
The last time we were together, we learned how to use the MERGE statement when we wanted to insert rows that didn’t exist and update rows that didn’t. This time we’re going to add onto that. We’re adding the seldom used, but delightfully potent – delete rows that no longer exist in the original table. … More Merging Data Sources Part II