Home Forums SQL Server 2012 SQL 2012 - General After insert trigger not working correctly with multiple inserts RE: After insert trigger not working correctly with multiple inserts

  • Not sure what you mean by not working correctly but if you change that insert to be:
    VALUES
    (1,1),(1,1), (1,1), (1,1), (1,1)

    Then the batch number is the same for five rows. If the repeating batch number is the issue then that's how they work. Triggers fire once per batch.

    Sue