Introduction to DML triggers
When the data in the table in the database changes, including any operation of insert, update, delete, if we write the corresponding DML trigger to the table, then the trigger is automatically executed. The main role of DML triggers is to enforce business rules, and to extend Sql Server constraints, default values, etc. Because we know that constraints can only constrain data in the same table, and triggers can execute arbitrary Sql commands.