Good question and I learnt something 🙂

I wonder how many of those who got it right (70% at the moment) did so without running the script first!

Fortuntely I was fibbing and we actually convert to proper dates before passing to SQLServer 🙂

Hugo Kornelis (10/27/2010)

---

For the datetime data type, The only formats that are guaranteed to work correctly in all circumstances are:

* yyyymmdd - for dates without time portion. No dashes. dots,...

Not at all.

But the answer as given doesn't depends on SQL, but on how you interpret the phrase "the status bar". ...

Pedantic trickery at its worst!

"the status bar in SQL Server 2008 Management Studio" does not clearly state that it means the one in the main window rather than the one...

I got this right because we've been bitten by the same thing with VB6, which also uses bankers rounding. We had to write our own rounding method to get it...

What a bizarre question!

Hugo Kornelis (10/5/2010)

---

After answering, I was shocked to see a score of only 39% (at that time) correct answers. Almost half the people (48%, to be precise) apparently STILL think...

"Me too" on the incorrect options stuff.

But in any case, 1 point is a bit mean for a 4-checkbox multiselect question

edit - replied to the wrong topic!

Hugo Kornelis (9/27/2010)

That all being said, I completely fail to see the acutal use of a function that tells me that a string value "is either a number or its...

tommyh (9/27/2010)

---

True but atleast 1 and 1 are both numeric both in and out off context. Wheras "e" is only valid under some circumstances. With "11" you can do any...

I agree, in fact I'd go further and say that a...

Rune Bivrin (9/24/2010)

---

most of the time it doesn't matter why it's empty because all that's done with the contents is display it in reports and dialog boxes. In those cases...

Rune Bivrin (9/24/2010)

---

However, looking the table in the question I'd probably remove the NULL-ability on the cell phone numbers. Nullable VARCHAR often doesn't make sense. Particularly when they are entered...