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


T SQL


T SQL

Author
Message
ChiragNS
ChiragNS
SSCertifiable
SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)SSCertifiable (6.8K reputation)

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

"Keep Trying"
Adi Cohn
Adi Cohn
SSCrazy Eights
SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)SSCrazy Eights (8.3K reputation)

Group: General Forum Members
Points: 8345 Visits: 6595
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
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5217 Visits: 11878
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: 1091 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
SSCommitted
SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)SSCommitted (2K reputation)

Group: General Forum Members
Points: 1962 Visits: 969
Darn.

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

Group: General Forum Members
Points: 895 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
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1937 Visits: 1109
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
SSC Eights!
SSC Eights! (890 reputation)SSC Eights! (890 reputation)SSC Eights! (890 reputation)SSC Eights! (890 reputation)SSC Eights! (890 reputation)SSC Eights! (890 reputation)SSC Eights! (890 reputation)SSC Eights! (890 reputation)

Group: General Forum Members
Points: 890 Visits: 1048
So I'm not the only one thinking the options given are wrong!
sjimmo
sjimmo
SSCarpal Tunnel
SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)SSCarpal Tunnel (4.8K reputation)

Group: General Forum Members
Points: 4842 Visits: 2907
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 (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)Old Hand (324 reputation)

Group: General Forum Members
Points: 324 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