Viewing 14 posts - 1 through 14 (of 14 total)
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...
March 30, 2020 at 6:22 am
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...
March 11, 2020 at 12:05 pm
April 28, 2017 at 12:11 am
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...
March 1, 2017 at 11:56 pm
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...
November 1, 2016 at 1:36 am
Yes clearly. Otherwise it will of course not throw an error, because there is no row that the query will attempt to update.
September 15, 2016 at 1:59 am
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...
September 15, 2016 at 1:16 am
Thanks Andy! No Points for me, but getting a reason to read up on sparse columns and their limitations is much appreciated.
September 5, 2016 at 1:51 am
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.
April 28, 2016 at 12:32 am
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...
June 10, 2015 at 3:53 am
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.
June 12, 2012 at 11:25 pm
June 12, 2012 at 6:54 am
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...
June 12, 2012 at 5:08 am
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.
June 11, 2012 at 4:24 am