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.

    Ron

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

  • Gobikannan

    SSCrazy

    Points: 2735

    Nice question with nice explanation.

    -----------------
    Gobikannan

  • Koen Verbeeck

    SSC Guru

    Points: 258955

    Great question!

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • srikant maurya

    Hall of Fame

    Points: 3293

    Good Question,

    Srikant

  • sharath.chalamgari

    SSCertifiable

    Points: 5680

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

  • nigel.

    SSChampion

    Points: 11591

    Excellent question !

  • cengland0

    SSCertifiable

    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".

    Tom

  • Richard Warr

    SSCertifiable

    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

    Grasshopper

    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

    SSCertifiable

    Points: 5847

    Excellent question and better explanation.

    Malleswarareddy
    I.T.Analyst
    MCITP(70-451)

  • M&M

    SSC-Insane

    Points: 21679

    Really good question

    M&M

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

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