fregatepllada (8/1/2014)
... ... Create, Update and Delete SPs would work against table and I prefer this way because I could operatewith 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