Did the question make you think?

If the answer was given as 'INNER' instead of 'MIDDLE', wouldn't you just have picked that without bothering to check?

I can't speak for anyone else...

Although I got the right answer, it is not true to say that the results exactly match the results of sp_who

sp_who resolves the database name (dbname) correctly whereas the query...

Four pages of comments - all the same

Doesn't anybody read previous comments before blithely jumping in and stating the obvious

Well I'd better start it up again then

How can a question like this get through QA ? I'm really upset - It's hard enough...

Guys, I appreciate that the question was not worded correctly but you should be getting used to these by now

You could have guessed that...

I have the answer!

If the connection is made through TCP/IP, the nt_username and nt_domain columns are empty.

If the connection is made through named...

Thanks for you replies but I am, unfortunately, still no nearer finding a solution. SUSER_NAME() and SUSER_SNAME() both return the login user, not the NT user name.

Also, it is not...

How bizarre to have a question on an unreleased product

Sorry - tried this again from SEM instead of query analyser (after reading the question a little more carefully!)

Agree with results as previously posted - however, I feel that this...

Sorry Ed. I can't agree your results. Both queries work fine. I tested them both.

I think this "BUG" is not in all installations of SQL 2000 - ergo the question...

I agree. I can't find any differences between 3 and 4.

Both turn on ANSI_NULLS for the duration of the query.

Furthermore, I can't agree with the link to the BUG. Is...

I take it all back on the basis that I cannot now replicate

I rebuilt the query from scratch and got the expected results that...

I take it all back on the basis that I cannot now replicate

I rebuilt the query from scratch and got the expected results that...

Hi Gregory. Yes agreed, 2 returned. However, as the question says, are you relying on the fact that the order of the data in table B is ordered as 1,...

Despite the typo, I assumed that the second query was the result of #TestUpdateB.

I assumed the answer would be 'cannot be determined' but I did a little test beforehand. I...