Home Forums SQL Server 2008 SQL Server 2008 - General How To Update NUll Enabled Field Without Interfering With The Rest of the INSERT/UPDATE RE: How To Update NUll Enabled Field Without Interfering With The Rest of the INSERT/UPDATE

  • The on-going maintenance is higher for an INSTEAD OF trigger, since every column addition or deletion, and some column changes, all requires changes the trigger, which is not the case with an AFTER trigger on only specific columns.

    SQL DBA,SQL Server MVP(07, 08, 09) A socialist is someone who will give you the shirt off *someone else's* back.