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 5:49 pm

    #1617648

    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.

    _____________
    Code for TallyGenerator