Good question. Managed to get it wrong by not noticing that decimal wasn't decimal(7,2). Probably wouldn't have got it right even if I'd noticed.

There seems to...

Interesting question. A couple of people have pointed out the hole in the question.

I was careless about the ordering in query C, and thus got it "right...

Nice question.

That, Andy, is I think the least complicated QotD from you yet :-). Asd it's certainly one that no-one could sensibly complain about.

I always find myself somewhat amused when anyone argues that the default is what you get by hitting the button marked "customise" and using the dialogue that brings up to...

Oz

Eirikur Eiriksson (6/25/2014)

---

TomThomson (6/24/2014)

---

Luis Cazares (6/24/2014)

---

On a completely different subject, I'm taking 20467BC course this week and found some surprises like using while loops to create sample data, recommendations...

dream

Nice question. A bit convoluted to do in ones head, but in reality the only difficulty is working out whether the first query returns 1 or 2 rows, ie...

Luis Cazares (6/24/2014)

---

On a completely different subject, I'm taking 20467BC course this week and found some surprises like using while loops to create sample data, recommendations to use partitioning...

It's only easy for people who have some idea how resource pools work. Most people make...

Nice question.

Would it have been a better question or worse one if the create synonym statement had been the first in the batch, ie before thecorresponding table was...

Sean Lange (6/19/2014)

---

Ed Wagner (6/19/2014)

---

jasona.work (6/19/2014)

---

Ed Wagner (6/19/2014)

---

SQLRNNR (6/19/2014)

---

Stuart Davies (6/19/2014)

---

Sean Lange (6/19/2014)

---

SQLRNNR (6/19/2014)

---

JAZZ Master (6/19/2014)

---

SQLRNNR (6/19/2014)

---

Ed Wagner (6/19/2014)

---

crookj (6/19/2014)

---

Ed Wagner (6/19/2014)

---

djj (6/19/2014)

---

Ed Wagner (6/19/2014)

---

crookj (6/19/2014)

---

Ed Wagner (6/19/2014)

---

Stuart Davies (6/19/2014)

---

rhythmk...

Carpe Datum (6/19/2014)

---

Koen Verbeeck (6/19/2014)

---

I think the motive behind the question is something like this:

the developer has no clue what actual permissions he needs, so he aims for the big...

I don't like this question and answer at all.

There's another problem too: either this is apparently going to happen on a production database which needs to be locked down, otherwise...

SQLRNNR (6/18/2014)

---

Sean Lange (6/18/2014)

---

Ed Wagner (6/18/2014)

---

Sean Lange (6/18/2014)

---

Ed Wagner (6/18/2014)

---

sing4you (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Sean Lange (6/18/2014)

---

Ed Wagner (6/18/2014)

---

JAZZ Master (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Ed Wagner (6/18/2014)

---

SQLRNNR (6/18/2014)

---

Sean Lange (6/18/2014)

---

whereisSQL? (6/18/2014)

---

Ed Wagner (6/18/2014)

---

JAZZ Master (6/18/2014)

---

Stuart Davies...