Viewing 15 posts - 121 through 135 (of 163 total)
(*) I only have SQL Server 2008 R2 with SP1 installed, so I can't reproduce the bug. Maybe someone who does have an older version with the bug still in...
November 8, 2011 at 7:33 am
Carlo Romagnano (10/21/2011)
CREATE VIEW vw_clients ASSELECT TOP 100 PERCENT Code, Name FROM Clients
ORDER BY Code
I am curious to know if the VIEW above always returns records in sorted order.
As...
October 21, 2011 at 5:03 am
I didn't like the "explanation".
What I am missing is the real explanation why the sub query in the EXISTS doesn't result in an error.
It actually matters what is in...
August 3, 2011 at 1:16 am
murray-906152 (7/19/2011)
There is NO query returning zero rows in the question.
There is one insert statement yielding five rows affected.
You might...
July 20, 2011 at 12:43 am
Gianluca Sartori (6/28/2011)
Let me ask one question: this page on MSDN states that:
Server execution plans have the...
June 28, 2011 at 1:18 am
I would like to know why option 2 is not correct.
Apparently more options are correct, and looking at the future, this should even be the preferred option.
March 15, 2011 at 3:29 am
Carlo Romagnano (12/23/2010)
If you get 1,2,3,4
that means that in the script you do not report single line comments.
The script in @sql looks like this:
PRINT 2 is joined to...
December 23, 2010 at 3:11 am
Looking at the percentage of incorrect results, and the percentages per answer, I wonder if people missed the "in" in "incorrect" in the question.
November 11, 2010 at 1:59 am
Wrong!
SQL Server will return a result set that consists of two columns (both datatype numeric(3,2)), and one row. The values in this row are 2.5 and 3.6. (Or 2.50 and...
October 13, 2010 at 2:03 am
My opinion is that none of the answers is correct.
SQL Server will return 2.50 and 3.60, not 2.5 and 3.6.
October 13, 2010 at 1:06 am
If the question was aiming at showing what the behaviour is of having "GO" in a batch, then it would have made sense to add the answer "The select statement...
June 11, 2010 at 8:04 am
Quite a waste of time trying to answer this question.
Lesson learned here should be: How NOT to write a QotD!
June 11, 2010 at 5:17 am
forjonathanwilson (6/8/2010)
Nailed it, because I assumed that "person" was not me. If I were "person" the answer would have been 5.
Or if the default schema of the user executing it...
June 9, 2010 at 1:04 am
I also have to press Ctrl + left mouse button in order to open the link.
I don't see a pop-up either.
March 24, 2010 at 2:10 am
How can the community be responsible for the answers if they/we don't have the means to decide on changing the answers?
The submitter posts the question with answers, which will make...
March 19, 2010 at 3:08 am
Viewing 15 posts - 121 through 135 (of 163 total)