Ayan
Reputation: 17
How to fire trigger only once after insert into statement execution (multiple insert)?
How to fire trigger only once after insert into statement execution (single insert into -> multiple insert) ?
Upvotes: 0
Views: 831
Answers (1)
David Browne - Microsoft
Reputation: 89091
SQL Server has Statement Triggers, not Row Triggers. A single INSERT statement will fire a SQL Server trigger only once, even if the INSERT affects multiple rows.
DML triggers is a special type of stored procedure that automatically takes effect when a data manipulation language (DML) event takes place that affects the table or view defined in the trigger. DML events include INSERT, UPDATE, or DELETE statements.
Upvotes: 4
Related Questions
- Trigger to handle Multi Insert Statements
- How do I make the "Inserted" return one value per insertion into the table?
- Trigger handle multiple inserts
- Creating A Trigger When Insert Is Already Done
- SQL Server Inserting multiple rows using Triggers
- SQL Server AFTER INSERT Trigger updating a 2nd table multiple times per insert
- SQL Server Insert trigger inserting more than once
- UPDATE and INSERT should fire trigger only once
- How trigger will fire on multiple rows insert in single transaction
- SQL TRIGGER handling multiple INSERTED rows