April 24, 2011 at 7:34 am
Comments posted to this topic are about the item OUTPUT & NEWID()
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 24, 2011 at 7:34 am
Good question. Thanks
M&M
April 24, 2011 at 9:00 am
From:
http://dictionary.reference.com/browse/guarantee
"something that assures a particular outcome or condition:"
Sorry but my language comprehension is that means the ONLY answers are 2 or 9 or 11 and NEVER another value.
But the given explanation is
Surprisingly, there can be any number of rows from ZERO to the number of rows in the table being deleted from
contradicts what is supposedly the correct answer.
Oh well, another question that does not rely on the workings of the database engine, but rather english comprehension.
April 25, 2011 at 1:51 am
Hello,
I think the correct answer is none of the above, because the result can be 8 for example,
and any of the above means the result must be 2 , 9 or 11 and not another value.
anywhere thanks for the question.
April 25, 2011 at 3:03 am
I answered "None of the above". After getting the explanation I still claim I answered right. The question was "... how many rows are gauranteed ...", so answer "Any of the above", well, questionable.
Interesting question though
April 25, 2011 at 5:50 am
Echoing here... since you're talking about garanteed # of rows, none is the only possible answer.
April 25, 2011 at 6:14 am
Jeez, I hate it when the answer depends more on figuring out the author's intent in the answer than actually answering the question.
If the answer is any number of rows can be returned, then 2, 9, or 11 are NOT guaranteed.
April 25, 2011 at 6:27 am
great question! Initially, I analyzed the text in question and then I found the command's return is not fixed, after running it several times, really it can be any value according the correct answer.
April 25, 2011 at 6:55 am
Am I the only one who thinks "none of the above" is the correct response, because the script is so buggy it won't compile?
Unless I'm crazy you can't insert 'a' into the nDex field because nDex is an integer. When that script is copied to SSMS you get 3 incorrect sytax errors.
So the correct answer is "none of the above". 🙂 Because it's *guaranteed* you won't get any return values!
April 25, 2011 at 7:15 am
roger.plowman (4/25/2011)
Am I the only one who thinks "none of the above" is the correct response, because the script is so buggy it won't compile?Unless I'm crazy you can't insert 'a' into the nDex field because nDex is an integer. When that script is copied to SSMS you get 3 incorrect sytax errors.
So the correct answer is "none of the above". 🙂 Because it's *guaranteed* you won't get any return values!
The insert will fail in 2k5, you have to change it to union alls... other than that the script will work (tho not as obviously intented and hence the question here)
April 25, 2011 at 7:25 am
It is a question of semantics. You are guaranteed to have ANY of those values and NONE of them at the same time. There is no guarantee, and yet there is one.
**YES THIS IS A TRICK QUESTION**
It's intent was to get you thinking, and spark conversation on the validity of Microsoft's statement that this is by design and not a bug.
I've asked Mr. Jones to mark both Any and All as valid answers. Unfortunately the QOTD engine does not allow multiple "possible" answers.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 25, 2011 at 7:25 am
QOTD reference says
there can be any number of rows from ZERO to the number of rows in the table being deleted from.
Which matches what I expected and what I saw when running the answer code.
Why is "none of the above" not the right answer.
I would like to see that explination.
Even a good understanding of english as a first language does not help figure out this.
Nice concept for a question, but seems the scoring in flawed.
:Wow:
April 25, 2011 at 7:29 am
Interesting question. I had no problem with the semantics of the question or answer.
Wondering if anyone can think of a real world example where one might want to use "ORDER BY NEWID()?" Just curious.
April 25, 2011 at 7:30 am
wware (4/25/2011)
Interesting question. I had no problem with the semantics of the question or answer.Wondering if anyone can think of a real world example where one might want to use "ORDER BY NEWID()?" Just curious.
It's a nifty way to randomize the order of a result set.
______________________________________________________________________
Personal Motto: Why push the envelope when you can just open it?
If you follow the direction given HERE[/url] you'll likely increase the number and quality of responses you get to your question.
Jason L. SelburgApril 25, 2011 at 7:31 am
wware (4/25/2011)
Interesting question. I had no problem with the semantics of the question or answer.Wondering if anyone can think of a real world example where one might want to use "ORDER BY NEWID()?" Just curious.
I did when doing reindexing during business hours. I wanted to make sure to not lock to same table over and over again so newid() on the final query made the cut... especially combined with waitfor delay
Viewing 15 posts - 1 through 15 (of 55 total)
You must be logged in to reply to this topic. Login to reply