Viewing 15 posts - 3,676 through 3,690 (of 7,484 total)
chgn01 (3/8/2013)
Did I am misleading for the answer?
NO, you are not misleading in any way, the only thing genuinely wrong with the question is using OBJECTID when DBID would have...
March 8, 2013 at 6:56 pm
Miles Neale (3/8/2013)
L' Eomot Inversé (3/8/2013)
Revenant (3/7/2013)
I am nominating this for the Most Misguided QotD of the Year Award.I think it's a poor fifth in that race. 😎
Tom, ...
March 8, 2013 at 6:35 pm
Primo Dang (3/8/2013)
buddy__a (3/8/2013)
I'm still waiting for someone to fix this. The answer saying "ORDER By is required when using a TOP clause" is clearly wrong.
It seems Steve isn't...
March 8, 2013 at 6:26 pm
mtassin (3/8/2013)
SQLRNNR (3/7/2013)
Looks like we may have a fun day with this question.
Well.... probably.... I got it right... I noticed the backwardsness... but the other two were obviously wrong... always...
March 8, 2013 at 6:20 pm
Revenant (3/7/2013)
I am nominating this for the Most Misguided QotD of the Year Award.
I think it's a poor fifth in that race. 😎
March 8, 2013 at 4:21 am
SQLRNNR (3/7/2013)
Jeff Moden (3/7/2013)
Paul White (3/7/2013)
Jeff Moden (3/7/2013)
I just can't understand why anyone would actually use XML. 😉The only possible reason is so you can say your indexes are SeXI.
That...
March 8, 2013 at 4:06 am
As many have pointed out, the third option is incorrect and teh fifth option is incorrect - so the supposedly right answer is horribly wrong.
It would have been a...
March 8, 2013 at 3:49 am
Good question.
This "create proc (or create function) must be the first thing in the batch" nonsense has long been one of my pet hates. Another is that proc bodies...
March 7, 2013 at 4:48 am
KWymore (3/6/2013)
chgn01 (3/6/2013)
Please try this:SET @vchrIsNumeric='$NAME',
Is Numeric or Is not Numeric?
That will return Is Numeric as well. Same thing if you do '£NAME'. I think any currency character will...
March 6, 2013 at 12:33 pm
Nice question, but I don't much like the heading. Fortunately I've learnt not to pay much attention to QotD headings.
March 6, 2013 at 4:53 am
Nice question, no ambiguities. Really good explanation - I very much liked that you took the trouble to mention that TRUNCATE TABLE works even when the clustered index is...
March 5, 2013 at 9:11 am
Evil Kraig F (3/4/2013)
Clean CLR isn't what scares my DBA's, it's letting my app coders loose with it.
Oh how things have changed! :w00t:
I remember the days when what scared...
March 4, 2013 at 10:44 am
Daniel Bowlin (3/4/2013)
crookj (3/1/2013)
Revenant (3/1/2013)
L' Eomot Inversé (3/1/2013)
sing4you (3/1/2013)
FLYPAPER
sticky
situation
room
L-shaped
March 4, 2013 at 10:31 am
james.parker 62839 (3/4/2013)
I understand and may even agree your dismay in the BOL description given with this answer.
I do not see any recomendations for correcting it or...
March 4, 2013 at 10:20 am
Viewing 15 posts - 3,676 through 3,690 (of 7,484 total)