Home Forums Article Discussions Article Discussions by Author Discuss content posted by Sergiy Best Practice RE: Best Practice

  • September 5, 2008 at 5:41 pm

    #868079

    I always use IF EXISTS(select 1 from inserted) or deleted.

    It allows not to run "insert" part of INSERT/UPDATE/DELETE trigger only when there are actually inserted rows.

    _____________
    Code for TallyGenerator