I've tested rbarryyoung's code again with a + instead, and it seems it does the ^ first, then the + sign, which indeed contradicts the BOL.

rbarryyoung (8/7/2008)

Iggy (8/7/2008)

@a^@a is a bitwise XOR, not an exponent operation. Any value XOR'd with itself is always 0. Subtracting 17 makes it -17, which is a negative number, and...

@a^@a is a bitwise XOR, not an exponent operation. Any value XOR'd with itself is always 0. Subtracting 17 makes it -17, which is a negative number, and an invlaid...

I agree with Tony. If a seed is already specified, all subsequent call to the function RAND() in the same connection will be deterministic (i.e., same number). So that's why...

Thanks Steve!

BOL says:

So why is "Reporting Services, Integration...

I don't have SQL Server 2005 so I can't test, but according to the keyboard shortcut list on BOL (http://msdn.microsoft.com/en-us/library/ms174205.aspx) there is no ALT+F1 at all. Is this...

Hmm... I got this wrong, based on the BOL it's supposed to be FAST_FORWARD that is optimized for performance, but apparently, based on your paper, it's not. But I'm happy...

Good question, I never thought default values can be used for inserting identity value, I always thought it is meant to be for inserting default value only. I learn something...

I still see the red cross on my answer :w00t:

please please correct the answer so we all get our points back 😛

Makes me think whether I should be bothering answering these questions. There has been too many mistakes in QotD lately.

I think you misread the answer. The answer according to the author...

the third answer is incorrect, because it would have put the latest date of leaving first, instead of the earliest date of leaving first. Thus it will contradict the question...

I too voiced my protest against "sp_describe_cursor_columns" answer being incorrect.

And I don't think the author reads this thread. Just like the other author (whether he/she is the same or not)...

.WRITE is only valid for varchar(max), nvarchar(max), or varbinary(max), but NOT for TEXT column, so your answer is incorrect.

I want my points. The correct answer should be UPDATETEXT (to update,...