Is there anyway to make COUNT() to consider even NULL values?? I mean any set options or something like that?

Nice question..

Somebody tell me what does that ALL mean in a select statement (4th option)..

Raghavendra Mudugal (4/17/2013)

---

Nice one, thank you for posting.

(I knew the row constructor can be used in inserting value with single insert and the separated by comma, but never made an...

I think it's more about CROSS JOIN than SUM & COUNT.. Nice One..

Again making the trick with length of the column.. Nice ..

Really a great QotD. No matter whether the wording of question or answer options are wrong. It triggered a great discussion where everyone understood the behaviour of On & Where...

Thanks for your detailed explaination Hugo. I can find definitions for each and every function seperately in BOL. But i can't find such relative explainations over there.

Thanks Hugo,

I have one more doubt, will ANSI_PADDING set option affects the datastorage?

Nice question.

paul.knibbs (3/26/2013)

---

This seemed so simple I went and ran the code, sure there must be a catch of some kind--turns out there wasn't, it was as simple as is seemed...

Nice one..

I'm not aware of that LEN() willl ignore trailing spaces. Thanks for making me to learn..

If somebody explains the difference b/w Datalength() & Len() in this thread will be...

I dindn't get any results on googling. So i guessed there won't be any such set options introduced yet in MS SQL Server.

Thanks for easy points..

Thanks for recalling the basics.

Still I have question, why it has been called as DDL command?

Lokesh Vij (3/20/2013)

---

+1

same here. i feel it is...