Column manipulation with ALTER TABLE

  • Arno Kwetters

    Hall of Fame

    Points: 3335

    Comments posted to this topic are about the item Column manipulation with ALTER TABLE

  • Arno Kwetters

    Hall of Fame

    Points: 3335

    Until now there are more incorrect then correct answers.

    Especially the ADD with the keyword COLUMN is a favorit incorrect answer.

    That is the reason why I posted this question, it suprised me also.

  • palotaiarpad

    SSCarpal Tunnel

    Points: 4891

    2 points?:cool:

  • Neil Burton

    SSC-Insane

    Points: 21946

    Dammit! I saw 'select three', mentally selected three, thought I'd physically selected three, only as I clicked submit did I see I'd only selected two. An easy two points missed; need more caffeine.


    On two occasions I have been asked, "Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?" ... I am not able rightly to apprehend the kind of confusion of ideas that could provoke such a question.
    β€”Charles Babbage, Passages from the Life of a Philosopher

    How to post a question to get the most help http://www.sqlservercentral.com/articles/Best+Practices/61537

  • Arno Kwetters

    Hall of Fame

    Points: 3335

    Hello BWFC,

    But now you got a point πŸ™‚

    But in your QOTD the dreaded red dot with cross appears... :pinch:

  • Richard Warr

    SSCertifiable

    Points: 6955

    Unusually I thought it was quite an easy question and that two points was a bit generous. But then I saw that more people were getting it wrong than right so it seems fair enough.

    _____________________________________________________________________
    MCSA SQL Server 2012

  • Hugo Kornelis

    SSC Guru

    Points: 64645

    I knew the answer, ticked (what I thought) the three correct options, then saw that I got it wrong, and the correct answer was exactly what (I thought) I selected.

    It is really a bummer that the "back" button in my browser never works on the QotD, because I wanted to see where I misclicked.

    Oh well.

    Thanks for the question, Arno!


    Hugo Kornelis, SQL Server/Data Platform MVP (2006-2016)
    Visit my SQL Server blog: https://sqlserverfast.com/blog/
    SQL Server Execution Plan Reference: https://sqlserverfast.com/epr/

  • Koen Verbeeck

    SSC Guru

    Points: 258942

    Great question, thanks.

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

  • Arno Kwetters

    Hall of Fame

    Points: 3335

    Yes, 2 points, I am not the one how decides that.

    But the statements are important enough

  • Hany Helmy

    SSChampion

    Points: 13321

    Ez question 4 me, as I am doing this staff a lot in my environment.

  • cgumprich

    SSC Eights!

    Points: 813

    Good, deceptively simple question. I got it right, but only because I nearly always get it wrong in the real world. :blush:

  • Arno Kwetters

    Hall of Fame

    Points: 3335

    Thanks to all who have the courage to answer this question before tomorrow.

    At this moment the incorrect answers are still the majority.

  • SQL_Hunt

    SSC-Dedicated

    Points: 33267

    Got 2 marks. Simple one to start my day.

    Thanks.

  • Ken Wymore

    SSCoach

    Points: 16391

    Nice and easy for me. One of the many benefits of writing out all of my create/alter/drop statements versus using the designer in SSMS is that I am very familiar with this syntax. πŸ™‚

  • Revenant

    SSC-Forever

    Points: 42467

    Ken Wymore (6/16/2015)


    Nice and easy for me. One of the many benefits of writing out all of my create/alter/drop statements versus using the designer in SSMS is that I am very familiar with this syntax. πŸ™‚

    +1

    Thanks for the question, Arno!

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

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