Viewing 15 posts - 481 through 495 (of 658 total)
Lynn Pettis (7/25/2011)
The question asked do both of these SELECT statements always return the same number of rows?
It does now, but didn't originally. The problem with making corrections to questions...
July 26, 2011 at 2:18 am
Toreador (7/22/2011)
malleswarareddy_m (7/22/2011)
Now onwards i will read the question properly.
How long I wonder before the next QotD where a literal reading of the question leads to the wrong answer, and...
July 25, 2011 at 6:44 am
Richard Warr (7/25/2011)
We know that "ID" was really "ModelID"
No we don't. The query refers to both columns so the rtable presumably contains both. It's entirely possible that the question was...
July 25, 2011 at 3:38 am
The answer must be "it depends", since we know nothing at all about the data. At the most basic, if the table is empty then the two queries must return...
July 25, 2011 at 2:34 am
malleswarareddy_m (7/22/2011)
Now onwards i will read the question properly.
How long I wonder before the next QotD where a literal reading of the question leads to the wrong answer, and another...
July 22, 2011 at 4:33 am
BenWard (7/20/2011)
it affected 5 rows.
or perhaps
it returned "5 rows"
😉
July 20, 2011 at 6:45 am
Ninja's_RGR'us (7/20/2011)
Agreed, but not this one. Steve and I gave this a good 2 weeks of thoughts to give the best possible experience to the members.
I think my problem...
July 20, 2011 at 6:09 am
BenWard (7/20/2011)
don't forget, if this question - or it's answer - was actually wrong it wouldn't have been published.
Sadly that's not the case. There have been many recent questions with...
July 20, 2011 at 3:05 am
My original thought was that there would be no rows returned as this was an insert.
But I then thought that was silly, and I was being unfair on the questioner...
July 20, 2011 at 2:56 am
robert.johnson2 (6/29/2011)
Apparently someone did not read the referenced article before submitting the QOD
Apparently someone did not read this lengthy thread before submitting their "me too" complaint 😀
June 30, 2011 at 9:33 am
I wonder which of the following (if either) is more efficient:
select @a = 1 where @b = 0
or
if @b = 0 set @a = 1
June 24, 2011 at 8:55 am
Koen Verbeeck (5/16/2011)
And the explanation doesn't mention why inserting NULL in another string doesn't result in NULL, but in an empty space instead.
That's what got me.
Surely it's a bug?
select 'Vinay,...
May 17, 2011 at 3:43 am
john.arnott (5/10/2011)
May 10, 2011 at 9:42 am
It can be really annoying when someone posts an interesting question, but the motivation behind it gets virtually ignored as people moan on with repeated posts complaining about the wording.
Who...
April 26, 2011 at 3:26 am
Viewing 15 posts - 481 through 495 (of 658 total)