Arthur Olcot (12/11/2014)
Carlo Romagnano (12/11/2014)
The answer is in the title!
The answer might be in the title, but as a newbie I went through my usual process of reading the question, picking an answer after researching the question if needs be, then running the code to double check before actually selecting an answer. However when I did this, I got some data back so I changed my answer and got it wrong. Can anybody suggest why? I'm running 2012.
The question is what would be the output in the message pane, not the number of rows returned in the results pane.. Judging by the number of people also going for the number of actual records returned (including myself!) many are tripping up on this question and mis-reading the intention
It isn't. Here's the question again: "How many rows will be affected in the Message Pane from the below query?" and the answer of course is 1. That single row contains the text "One row(s) affected" or whatever.
[font="Arial"]“Write the query the simplest way. If through testing it becomes clear that the performance is inadequate, consider alternative query forms.” - Gail Shaw[/font]
For fast, accurate and documented assistance in answering your questions, please read this article
Understanding and using APPLY, (I)[/url] and
(II)[/url] Paul White
Hidden RBAR: Triangular Joins[/url] /
The "Numbers" or "Tally" Table: What it is and how it replaces a loop[/url] Jeff Moden