SQL Server Education (by the geeks, for the geeks)
A DML trigger is a set of SQL statements which are executed when a DML (Insert/Update/Delete) event occurs in a database. A DDL trigger is set of SQL statements executed when …
Disable and Enable triggers in SQL Server Read MoreIn this blog we’ll look at Recursive triggers in SQL Server. Triggers are said to be recursive/nested when a trigger on a table calls another trigger on same or different table …
Recursive triggers in SQL Server Read MoreDML Triggers are stored procedures which are automatically executed when a DML operation is performed on a table/view defined in a trigger. A good use of trigger is to audit table …
Disadvantages of triggers in SQL Server Read More