/ Published in: SQL
This SQL statesment help you to understand which trigger is going to execute first and which one is going to execute last.
- SELECT name TriggerName,
- ROW_NUMBER() OVER (ORDER BY modify_date DESC) ExecutionOrder
- FROM sys.triggers
- WHERE parent_id = object_id('Table-test')
- ORDER BY modify_date DESC
You need to login to post a comment.