There is very little difference - cosmetic bits (changes of captitalisation, "Exec" instead of...

This is a beautiful question. It's a perfect illustration of the fact that you don't know something for certain until you've tried it yourself. I fell into the...

Mike C (4/14/2010)

---

tarquin (4/14/2010)

---

Wrapping hashbytes with checksum is not bad as long as you include all columns in your join as indicated and create the index including all columns required...

Mike C (4/14/2010)

---

I wouldn't expect many collisions with MD5 unless you're processing 2^64 or more rows. If you're getting collisions with MD5 or SHA I would immediately suspect the...

Grant Fritchey (4/14/2010)

---

Personally, I'm trying very hard to not be one of those people. I've got twenty+ years in IT and I hope that they are 20 distinct years as...

No surprise the contractor is dead. If he made a habit of taking the source code with him someone would soon put out a contract on him.

Rune Bivrin (4/14/2010)

---

It's important to note that SET @result = cast (@@rowcount as varchar) does NOT change @@ROWCOUNT. The first 1 comes from the last INSERT #n VALUES(3).

This is one...

Kit G (4/16/2010)

---

Tom.Thomson (4/16/2010)

---

What about the Hyperpotamus? A hippo after drinking...

mtillman-921105 (4/13/2010)

---

Speaking of tangents (sort of)...

I understand logically that NULL (as an unknown quantity) added or used in any other mathematical formula should = NULL.

But I still wish that SQL...

I liked Hugo's comment better than the explanation or the answer or the question (although, like Hugo, I got the point by guessing that the author wouldn't want the answer...

Nice editorial Steve. I find that MS is usually pretty much marketting oriented, but I've been pleasantly surprised on occassion, so I know they are capable of getting it...

Would that be a horse with an unusual blood glucose level?

Hypopotamus 😀 (would that be: under water; or small water ; or by...

GabyYYZ (4/16/2010)

---

Lynn Pettis (4/16/2010)

---

GabyYYZ (4/16/2010)

---

CirquedeSQLeil (4/16/2010)

---

GabyYYZ (4/16/2010)

---

Michael Earl-395764 (11/18/2008)

---

Is it me, or are the posted questions getting worse these days?

I just read a post by someone apparently in charge of...

jcrawf02 (4/16/2010)

---

Having a good day today. Working through a problem comparing two datasets and finding those that don't match from either. Thought about it, mocked up some data and tried...

NoNoNoNoNo!!! Not THE...