I do disagree with the people answering Synatx Error getting their points back. The text of the question gave the results of the statements clearly showing that the statements did...

To Sergiy,

Huh?

Did someone change the answers around on me?

It appears I worked out the correct answer, and then selected the wrong answer when I answered the question. Dang!

Thanks for pointing out my...

Hans,

the alias name is spelt as "UniqueId" (without "_") in the first statement and "Unique_Id" (with "_") in the second statement.

Don.

Another question seems to have the incorrect answer checked as the correct answer.

The correct answer of those listed is:

"SQL Statement A will return its recordset sorted by myiT.Unique_ID descending ,...

I'd just like to congratulate the author of the question on their well detailed explanation.

Regards,

Don.

I found the following quote on the MSDN site at:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/architec/8_ar_sa_6b3k.asp

"Using AWE Memory on Windows 2000

Microsoft® SQL Server™ 2000 Enterprise Edition uses the Microsoft Windows® 2000 Address Windowing...

This question needs correction.

It specifies the answer as 8GB, but then the explanation of the answer says it is 64GB, as does the documentation I've found.

Either the answer needs to...

I received the same error message as Hans.

The error message says to "BACKUP WITH FORMAT" - how do we do that through the dialog boxes and GUI of Enterprise Manager?

Does...

Try using a temporary table and join that to the address table.

Eg

CREATE TABLE #TEMP_BORR

(borr1fico varchar(50) not null,

borr2fico varchar(50) null,

borr3fico varchar(50) null)

INSERT INTO #TEMP_BORR

     SELECT ... (as you had above)

SELECT

TB.borr1fico,

TB.borr2fico,

TB.borr3fico,

AD1.street as...

I must say I do agree with Karsten. I can understand why system_user is supposedly correct, but without a context for comparison I would say that user_name() is also an...