Post reply

Column manipulation with ALTER TABLE

  • June 15, 2015 at 9:33 pm

    #309275

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

  • June 16, 2015 at 12:18 am

    #1805637

    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.

  • June 16, 2015 at 12:22 am

    #1805638

    2 points?:cool:

  • June 16, 2015 at 1:24 am

    #1805647

    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

  • June 16, 2015 at 1:33 am

    #1805648

    Hello BWFC,

    But now you got a point 🙂

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

  • June 16, 2015 at 3:10 am

    #1805664

    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.

  • June 16, 2015 at 3:44 am

    #1805672

    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/

  • June 16, 2015 at 4:48 am

    #1805686

    Great question, thanks.

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

  • June 16, 2015 at 4:53 am

    #1805688

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

    But the statements are important enough

  • June 16, 2015 at 5:54 am

    #1805710

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

    Thanks & Best Regards,
    Hany Helmy
    SQL Server Database Consultant

  • June 16, 2015 at 6:27 am

    #1805717

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

  • June 16, 2015 at 8:28 am

    #1805749

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

    At this moment the incorrect answers are still the majority.

  • June 16, 2015 at 9:28 am

    #1805772

    Got 2 marks. Simple one to start my day.

    Thanks.

  • June 16, 2015 at 10:38 am

    #1805787

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

  • June 16, 2015 at 10:59 am

    #1805798

    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 22 total)

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