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?
Answer by tiwaryrohit143 · Mar 08, 2019 at 01:32 PM
I have written for insert/update trigger. You can check the script attached. I will shortly write for delete. This will be helpful.
Answers Answers and Comments
21 People are following this question.
How to Create an alert for databases where Any object (Tables, Views and SP) should not be referenced
Exec query which is returned by another quer?y
Profit calculation for specific year
Script to find table dependencies of all stored procedure in a database
How to split a column value to two column values?