Assertion: trigger's statement | /r/HasProperty | executed
Facets:
Source sentences:
text: This gets executed before or after the specified column changes For each row type: This trigger gets executed once for each row of the result set affected by an insert/update/delete For each statement type: This trigger gets executed only once for the entire result set, but also fires each time the statement is executed.
text: Let's insert new rows based on the current contents of Orders to show how a trigger behaves when a multi-row statement is executed.
text: For example, a DDL Trigger may fire if a statement such as ALTER SERVER CONFIGURATION is executed or if a table is deleted by using DROP TABLE.