Home Forums SQL Server 2012 SQL Server 2012 - T-SQL Have I been smoking something?? Insert construction question. RE: Have I been smoking something?? Insert construction question.

  • May 22, 2013 at 11:48 pm

    #1617684

    Sergiy (5/22/2013)

    marc.snoeys (5/17/2013)

    That's basically my point 🙂

    There is nothing wrong with the INSERT-statement at all.

    But, my personal opinion is that it would be more intuitive to be able to write an INSERT-statement just like an UPDATE-statement.

    But that's merely a discussion on improvement/addition of syntax.

    Try to insert 2 or more records using your proposed syntax.

    Or implement a check for existence of a key value in the table.

    I could hardly name it any kind of improvement.

    That's a non-argument because you can't insert two or more records with the VALUES-syntax as well 😉

    "Walking on water and developing software from a specification are easy if both are frozen." -- Edward V. Berard, "Life-Cycle Approaches"