So Mr Harder, you last tax return..

we have some questions for you....

Just kidding!

(we'll see you later)

--Shaun

dude you crack me up!

SQL2000/SQL2005(Mode 80) DBA - 'Hey my results don't fit any of the available answers, the question is wrong!':unsure:

'I want the points!':angry:

Final thought from me (oh...

This thread has kept me entertained;

http://www.sqlservercentral.com/Forums/FindPost477574.aspx

What a wheeze! 😀

--Shaun

:crazy: Arrrgh! :crazy:

Thats it I'm not posting on this thread anymore!

Other than to say its been educational for me to see how many poor, naive, neophytes

have fallen for this question....

Terry,

Though you are correct in the statement that both are identical please see the post by wayne.mcdaniel this thread, page 6 I think.

(aliasing a different column to be the...

Where is the link to the ten commandments?

--Shaun

Ok thats the three rules of DBAs 🙂

What about the three rules of REBAR? :hehe:

Yes, for all SQL Server 6.5/7/2000/2005/2008 and any other relational/object database;-

If they do not return an error for this type of Select returning two identically named columns then they are...

'Twas a pleasure, mate!

(note to self must curb my caustic, mean, aggressive streak more). 😀

--Shaun

Your expectations are/were flawed/jaded by the slack implementation of SQL in SQL Server 2000 🙂

Your opinion is noted, but is incorrect. 😉

Correct SQL syntax behaviour is demonstrated by, dare I...

ayan_m:

Dude you need to chill.:)

The question of the day is merely a test of one's own knowledge and where it is found to be lacking one should profit from the...

People should read all the previous posts before commenting.

The last two guys obviously have learned nothing!:hehe:

SQL server 2000 is flawed and SQL server 2005 (mode 80) is flawed.

Mode 90...

Jeff are those the 'Three Rules'? 😀

akin to Asimov and Clarke

barb.w:

answer (a) is wrong not in the context of the SQL version you are running but in the syntax of the SQL used in SQL Server 2000 and 2005(mode 80).:)

The...

AF - I agree it was a poorly presented question. 🙁

(should have stated 2005/Mode 9 compatible).

But what a way to learn! 😉

You learn more from your defeats that from your...