SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


T SQL


T SQL

Author
Message
ChiragNS
ChiragNS
SSChampion
SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)SSChampion (14K reputation)

Group: General Forum Members
Points: 14607 Visits: 1865
I wonder how most of the people got the right answer. 55% when i checked.

"Keep Trying"
Adi Cohn
Adi Cohn
SSCoach
SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)SSCoach (19K reputation)

Group: General Forum Members
Points: 19400 Visits: 6653
Chirag (5/27/2009)
I wonder how most of the people got the right answer. 55% when i checked.


It was clear that answer number 1 had a type. Since the other answers were wrong, I was left with the answer with the typo and got it right.

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Steve Hall
Steve Hall
SSChampion
SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)SSChampion (10K reputation)

Group: General Forum Members
Points: 10015 Visits: 12349
Well it's obvious that there's something awry here, as an awful lot of people are getting the same (but apparently incorrect) answer.
What version of SQL Server (including Service packs) was this tested on?

Steve Hall
Linkedin
Blog Site
Leo Hesen
Leo Hesen
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1113 Visits: 248
Made the obvious mistake myself.

My assumption:
1 Not correct
2 Not correct
So it had to be 3 without examining this answer properly.

Reminded me to not jump to conclusions to early!
Always check everything.

Leo
Rachel Byford
Rachel Byford
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2468 Visits: 983
Darn.

I should know better than to bother with questions where I struggle to read the options!
jritson
jritson
SSC Eights!
SSC Eights! (939 reputation)SSC Eights! (939 reputation)SSC Eights! (939 reputation)SSC Eights! (939 reputation)SSC Eights! (939 reputation)SSC Eights! (939 reputation)SSC Eights! (939 reputation)SSC Eights! (939 reputation)

Group: General Forum Members
Points: 939 Visits: 295
Leo Hesen (5/27/2009)

Made the obvious mistake myself.

My assumption:
1 Not correct
2 Not correct
So it had to be 3 without examining this answer properly.

Reminded me to not jump to conclusions to early!
Always check everything.

Leo


Me too, I must read all the questions completely before jumping to conclusions - doh!
Scott-144766
Scott-144766
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2727 Visits: 1130
Leo Hesen (5/27/2009)

Made the obvious mistake myself.

My assumption:
1 Not correct
2 Not correct
So it had to be 3 without examining this answer properly.

Reminded me to not jump to conclusions to early!
Always check everything.

Leo


I did exactly the same as you. It's always reassuring to see other people making the same mistakes as myself - makes me feel a bit less stupid.txtPost_CommentEmoticon(':-)');

--
Scott
Balance
Balance
SSCommitted
SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)SSCommitted (1.5K reputation)

Group: General Forum Members
Points: 1530 Visits: 1048
So I'm not the only one thinking the options given are wrong!
sjimmo
sjimmo
SSCertifiable
SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)SSCertifiable (7.4K reputation)

Group: General Forum Members
Points: 7351 Visits: 2913
Amazing, I ran the code which supposedly has a typo, and the results were:
Em Ma
---------- ----------
Vyas Mohan
Mohan Shobha
Shridhar Mohan
Sourabh Mohan

(4 row(s) affected)

I must have read too fast.

Was the question tested and verified before it was posted?

Steve Jimmo
Sr DBA
“If we ever forget that we are One Nation Under God, then we will be a Nation gone under." - Ronald Reagan
dcawvive
dcawvive
Old Hand
Old Hand (384 reputation)Old Hand (384 reputation)Old Hand (384 reputation)Old Hand (384 reputation)Old Hand (384 reputation)Old Hand (384 reputation)Old Hand (384 reputation)Old Hand (384 reputation)

Group: General Forum Members
Points: 384 Visits: 149
Like everyone else seems to have, i discarded the first answer because there was NOT a second name in the third row. Yes I understand it's a typo but as it stands there is not a correct answer to choose from. I would have an issue with a developer that made the assumption that was what the end user meant instead of verifying it. (I know that would never happen in production. Right? :-P)
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum








































































































































































SQLServerCentral


Search