• fregatepllada (8/1/2014)


    ... ... Create, Update and Delete SPs would work against table and I prefer this way because I could operate

    with a set of records (bulk insert, update and delete via TVP) rather than struggle with RBAR anti-pattern

    introduced by INSTEAD OF triggers.

    Why do you think that INSTEAD OF triggers introduce a RBAR pattern? If the triggers are properly written they are set-oriented.

    Tom