Fails on MONEY type as well (using SQL2000)

The psychology of this is quite interesting.

If I won a trip into space, would I swap it for $100,000 ? I'm not sure, the temptation of taking the trip would...

The most commonly selected answer (so far) is "Query 3 and Query 4 will fail" (28%) which means many people think it's okay to put an order by clause inside...

#3 got me; didn't know that it would identify the correct column automatically in the order by clause. I would always specify the table in these circumstances, and thought...

I might have had to think twice if the possible answers had been April 30th, April 31st and May 1st.

I'm intrigued that (based on current figures) more than 30% of respondents think the person submitting the question shares none of the responsibilty for the accuracy of the answers. ...

INterestingly, and counter-intuitively, at least for me ...

SELECT cast(1.67574 as decimal(38,10)) /cast(10000 as decimal(38,10))

gives this result: .000167

While

SELECT cast(1.67574 as decimal(38,10)) /cast(10000 as decimal(38,1))

gives this more accurate result.000167574

Lynn Pettis (11/17/2009)

---

So, you are saying that if I run the following code:

select getdate(), getutcdate()

that the values are not equivalent? Why? They both represent the same moment in...

vk-kirov (10/14/2009)

---

I am disappointed with the question, too.

If I copied the script into SSMS, I would get the right answer. Instead, I took a piece of paper and wrote binary...

cengland0 (10/9/2009)[hr

The creator of that term worked for Boeing when it was created so it could stand for Boeing.

The creator's last name is Bayer so it could stand for Bayer.

The...

DavE E (3/24/2009)

---

I understand all this but why doesn't Microsoft make everyones life easier and make it work as everyone expects

i.e. NULL does equal NULL

So we can use ...

Longer than that, surely. I think it was available in Access 2.0 ( around 1993 ?), maybe earlier.

I wonder where Nancy Davolio is now...

The reliability of what goes into databases and files has always been an issue.

One of my favourite quotes about this (from a suitably cynical British administrator in colonial Inda):

"Governments are...

Phil, I'm really not sure what you are arguing for here.

A friend of mine was mistakenly put onto a government database in the UK because he has the same name...

Actually that just about makes sense, based on the assumption that "--" is ignored within block comments

so in this code:

/*

print '1'

--/**/note unmatched block comment marker on this line, following...