I want a script to create trigger dynamically. I have 100 tables and i need to create insert and delete trigger.
Thanks in advance.
Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.
What have you tried thus far?
I have written for insert/update trigger. You can check the script attached. I will shortly write for delete. This will be helpful.
21 People are following this question.
How to Create an alert for databases where Any object (Tables, Views and SP) should not be referenced
Profit calculation for specific year
Exec query which is returned by another quer?y
How to split a column value to two column values?
Script to find table dependencies of all stored procedure in a database