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


T SQL


T SQL

Author
Message
ChiragNS
ChiragNS
Hall of Fame
Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)Hall of Fame (3.5K reputation)

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

"Keep Trying"
Adi Cohn
Adi Cohn
Hall of Fame
Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)Hall of Fame (3.7K reputation)

Group: General Forum Members
Points: 3713 Visits: 6512
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
SSCrazy
SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)SSCrazy (2.8K reputation)

Group: General Forum Members
Points: 2847 Visits: 11573
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: 1071 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 (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)SSCommitted (1.7K reputation)

Group: General Forum Members
Points: 1692 Visits: 963
Darn.

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

Group: General Forum Members
Points: 875 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.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: 1536 Visits: 1102
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
Mr or Mrs. 500
Mr or Mrs. 500 (588 reputation)Mr or Mrs. 500 (588 reputation)Mr or Mrs. 500 (588 reputation)Mr or Mrs. 500 (588 reputation)Mr or Mrs. 500 (588 reputation)Mr or Mrs. 500 (588 reputation)Mr or Mrs. 500 (588 reputation)Mr or Mrs. 500 (588 reputation)

Group: General Forum Members
Points: 588 Visits: 1048
So I'm not the only one thinking the options given are wrong!
sjimmo
sjimmo
Hall of Fame
Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)Hall of Fame (3.8K reputation)

Group: General Forum Members
Points: 3766 Visits: 2904
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
SSC Veteran
SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)SSC Veteran (290 reputation)

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