Hakim,

This is good.

Sometime in the past I read that you were supposed to use information_schema instead of the sys tables for this...

Little late, but I was looking for something else and saw this one today. I run across this all the time, and was wondering why something like the following...

While I know you are not supposed to be able to add multiple GUIDs to any table, on the systems I have worked on I have found that with table...

Good Question. Learn something new every day.:-)

I think the question would have demonstrated the concept better if it had been the following:

CREATE TABLE dbo.Zip_code

(

id VARCHAR...

Not sure what system the author ran the script on, but I ran it in Management Studio 2005 version 9.00.1399.00 and got 1,2,3,4. Also ran it in Management Studio...

The problem is that the two queries are not equivalent. It has nothing to do with the order of the joins. If you notice, the records for a and...