The "how it will work" description makes no sense, unless you are going to add products only in batches of 20. Even if it it were adapted to work...

Jeff Moden (7/29/2010)

---

I've heard such things of Date which is surprising since Codd and Date were business partners at one time (IIRC). I'll have to take a look at...

David Portas (7/29/2010)You are unfairly misrepresenting the view of Chris Date (and many others). No one is talking about sweeping missing data under the carpet. If data is missing then...

Jeff Moden (7/28/2010)

---

Since Codd rather well endorsed NULLs, why are they considered such an irritant even by some of those that appear to follow his every word with nearly religious...

Amazing, especially the one from someone who's apparently an MVP. Perhaps...

GilaMonster (7/28/2010)

---

There have been some really 'entertaining' questions lately. There have been some 'entertaining' replies too.

So far this week I've seen two different people advocating backing the log up in...

John Rowan (7/28/2010)

---

Now your challenge will be to get both since most income equations involve trading one for...

So in...

Hugo Kornelis (4/21/2010)

---

I never understand that habit. The semicolon is a statement terminator, not a statement starter, so the logical place for it is at the end of a statement,...

Luke L (7/27/2010)

---

Nope, run the code you get 7 and 8 respectively. The Distinct in the second query is applied after the rows are created. So since there...

Interesting editorial, Steve, and fab picture.

I suspect that SA with blank password, default instance, DBMS on the same server as the website and set up to use default port numbers,...

Nice article, nice simple examples. Well done, Wayne.

timothy.bates (7/23/2010)

---

We have all tried to explain that NULL does not equal 0 or NULL to an end user and often the response I've gotten is "That's STUPID!" This...

I guess...

Good question. I got it wrong, because I didn't notice that the length wasn't specified. That will teach me not to skim read code when working out what...