Altering Included Indexes

  • tnpich

    Ten Centuries

    Points: 1131

    I have to agree with others. orderstatus not part of the table so option 4 fails as well. Only 1 valid option.

    Do we all get a bonus point then? 😉

  • fp-844866

    Grasshopper

    Points: 10

    Sorry, *YOU* were wrong. There is no column orderstatus!

  • paul s-306273

    SSChampion

    Points: 10588

    Wow - what's happened to the season of goodwill?

  • Marcia J

    SSCertifiable

    Points: 5635

    Glad I'm not the only one that was puzzled by #4. Oh, well. Mistakes happen.

  • rich.leick

    Newbie

    Points: 4

    Like the others have already mentioned. You can't alter a column that doesn't exist.

  • DTML

    SSC Enthusiast

    Points: 177

    There is no existing column orderstatus so that last option is not possible.

  • Joshua M Perry

    SSCrazy

    Points: 2655

    #4 will result in an error since the orderstatus column does not exist...not sure how that is part of the correct answer.

  • SQL_Hunt

    SSC-Dedicated

    Points: 33267

    Soemthing is wrong here in the question. I guess the choice should be "only 1".

    orderstatus can not be changed to "OrdeNotes" as summarynote is dependent on OrderNotes!!

    Thanks.

  • MMartin1

    One Orange Chip

    Points: 27488

    SQL-DBA-01 (12/30/2015)


    Soemthing is wrong here in the question. I guess the choice should be "only 1".

    orderstatus can not be changed to "OrdeNotes" as summarynote is dependent on OrderNotes!!

    +1

    I avoided this answer just for that reason

    ----------------------------------------------------
    How to post forum questions to get the best help [/url]

  • Just Will

    SSC Rookie

    Points: 48

    I hate to "me too" this, but I can't +1 -- I jumped on this for easy points, and the "right" answer is wrong...

  • vecerda

    SSCrazy

    Points: 2532

    yep sure is

  • Mauricio_

    SSCrazy

    Points: 2813

    Interesting, you can alter a column that doesn't exist 🙂

  • TomThomson

    SSC Guru

    Points: 104772

    So we are all left guessing as to which incorrect answer is a typing error.

    I guessed that it was the 3rd option because it is eminently sensible to require that saledate not be null if saleid isn't, and saleid is the primary key, so maybe shipdate in that option was an mistake for saledate, especially as a shipdate might well be null for some time after a slae has been made and an entry created in this table. But the error was in a different option and involved both altering a nonexistent column and a syntactically invalid GO.

    So the last two days of the year both have questions where it's impossible to get the answer except by pure guesswork. Not a good end to the year, or to the week.

    Anyway, happy new year, Steve.

    Tom

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the index question.

  • Toreador

    SSChampion

    Points: 11230

    I'm astonished that nobody has mentioned this yet, but option 4 will fail as there is no such column.

    Perhaps everyone is using the discussion to learn and share information, rather than moaning about a minor typo and saying the same thing that has already been said a dozen times or more...

Viewing 15 posts - 16 through 30 (of 33 total)

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