Identity Crisis: Attack of the Clone

  • dun

    Say Hey Kid

    Points: 708

    Comments posted to this topic are about the item Identity Crisis: Attack of the Clone

  • Ron McCullough

    SSC Guru

    Points: 63877

    Nice question - required carefully reading .. but that is how the QOD should .. so again nice question.

    If everything seems to be going well, you have obviously overlooked something.


    Please help us, help you -before posting a question please read[/url]
    Before posting a performance problem please read[/url]

  • Gobikannan


    Points: 2735

    Nice question with nice explanation.


  • Koen Verbeeck

    SSC Guru

    Points: 258955

    Great question!

    Need an answer? No, you need a question
    My blog at
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • srikant maurya

    Hall of Fame

    Points: 3293

    Good Question,


  • sharath.chalamgari


    Points: 5680

    Simple One i just need to read the question and answers carefully 🙂

  • nigel.


    Points: 11591

    Excellent question !

  • cengland0


    Points: 6102

    Nice question but this one almost had me because of the extra comma in the CREATE TABLE part of the query. When there wasn't a distractor with an error message to address that issue, I assumed that the creation of the table would have to work with the extra comma.

  • damir60

    SSC Enthusiast

    Points: 188

    too simple.

  • TomThomson

    SSC Guru

    Points: 104772

    Nice question.

    One niggle: asking people to assume that a schema is valid when a table doesn't have a primary key may encourage a very bad habit if some of your audience don't know any better. Maybe "pretend" would have been a better choice of word than "assume".


  • Richard Warr


    Points: 6955

    A question that enables most people to get the correct answer after some careful thought is by no means "too simple". Especially as over 1/3 of respondants have got it wrong.

    For me this was close to a "Goldilocks" question. For some it's too hard, for others too soft, but for many, it's just right.

    MCSA SQL Server 2012

  • sread


    Points: 13

    Won't the create table statement fail due to the comma after the last column name?

  • chrisfradenburg

    SSCrazy Eights

    Points: 9592

    sread (5/11/2011)

    Won't the create table statement fail due to the comma after the last column name?

    I just tried it on my machine and it ran fine. I do remember this being discussed someplace as being legit and someone mentioning that they have made a practice of doing to make it easier to add columns (one less thing to forget).

  • malleswarareddy_m


    Points: 5847

    Excellent question and better explanation.


  • M&M


    Points: 21679

    Really good question


Viewing 15 posts - 1 through 15 (of 36 total)

You must be logged in to reply to this topic. Login to reply