vk-kirov (10/10/2011)

---

Nice question

codebyo (10/10/2011)

---

That looks and executes right... but I can't understand why the result is not only the number 4.

After the EXCEPT, only the number 4 remains. So where...

stewartc-708166 (10/10/2011)

---

This is a good question, showing that care needs to be exercised when working with NULLs

Ajay.Kedar (10/10/2011)

---

I tried and got wrong in first select case 🙂

But wanted to know...

Scary question, I went with what the answer was but I was ready for a long discussion over a typo.

Scary question, I went with what the answer was but I was ready for a long discussion over a typo.

Thanks for the question

A nice easy one for Monday morning.

Even according to the MSDN article

TRUNCATE TABLE cannot activate a trigger because the operation does not log individual row deletions.

Emphesis mine.

Good question, nice little brain teaser for a friday morning.

How do you add the pressure of real-life in it? That version of the questions seems a little too easy (people like to have harder questions after years doing...

Ask it like a real-world situation.

1. Put line numbers by each line of your code.

2. State that you expected to get x number of results but you get no...

Are you being serious you want me to read your explaination AFTER answering the question?

Really?

The explaination of the...

I notice the mistake, but since that has been common in the QoTD I took it just as that a mistake... tough question, set's a dangerous precedence of having to...

Never Mind, I had another table test in the db, nice.

I ran this on a 2005 box and got an insert error

Insert Error: Column name or number of supplied values does not match table definition.

** An error was encountered...

Good question, thanks

Knew about 445, but not about 139, so I learned something new.