HASHBYTES is meant for a literal string (or binary) import of one column, so any potentially null fields would need to be wrapped in ISNULL(x,'') - and that's assuming you...

R.P.Rozema (1/16/2013)

---

Excellent article indeed. However like in most articles on merge, you do not mention the fact that merge doesn't have a where clause. i.e. if you want to use...

paul.barbin (1/16/2013)

---

Curious to hear from others on whether they use the MERGE command in production and what it's performance is like.

We began using it in our unit test scripts to...

Yes, QUOTENAME is my preferred method of dealing with dynamic SQL. Especially since it can also handle brackets.