This is not a correct answer. There's no -m flag. From the documentation, @@cursor_rows returns -m if the cursor is being asynchronously populated. That just means a negative value m is returned by the...

This is fun code to test and try to get ones head around - in which orders are operators applied.

 

DECLARE @i INT=0;
UPDATE t SET @i = id...

Nice question Steve. I'm not too familiar with OBJECTPROPERTY, but this got me Reading the documentation. Thanks!

But (there's always one), I answered that this can't be done with...

Very good question. I got it wrong, because I couldn't (apparently) read this early in the morning 🙂

But a very good example of where inexperienced developers tend to get things...

Yes clearly. Otherwise it will of course not throw an error, because there is no row that the query will attempt to update.

I don't Think the correct answer is correct.

When I try to update a view (defined using WITH CHECK OPTION) with a value which makes the row fall outside of, I...

Thanks Andy! No Points for me, but getting a reason to read up on sparse columns and their limitations is much appreciated.

In the code provided with the question, ESCAPE_QUOTE is used, which is not a valid macro. It should be ESCAPE_SQUOTE or ESCAPE_DQUOTE.

The QotD from June 8 includes the disabling of indexes. That part of the code was not pasted into this QotD, so like many already mentioned, neither of the answers...

Now that I (surprisingly) passed 71-461 I'm banning myself for not signing up for more beta certifications. I did 71-464, but I should have taken 465 and 462 as well.

jeff.mason (6/12/2012)

---

Sounds like the results are in then for 461, 462, and 463. I took the former two and passed. Not in yet on 464 or 465. ...

I logged in to Prometric (didn't even know it was possible) site and see that 71-461 (Querying) has status "Passed".

So I guess I'm buying the cake for the afternoon...

I too wonder when the results will be sent out. The "real" exams 70-46[1..7] are available from today, so I had expected to receive my results already.