Rick Todd (5/11/2010)
ziangij, I would definitely recommend reading through some of the comments, but here's my summary:If you have other logic to prevent/handle collisions, checksum might be fine. If you want to rely on the checksum/hashbytes method to do all of your new/update/existing logic, you definitely need hashbytes over checksum.
apologies, i should have read all the comments which I have done now.
many options have been suggested with pros and cons of each... 🙂