Dynamic trigger for delete and insert

Question

question

tiwaryrohit143 asked Mar 7, '19

I want a script to create trigger dynamically. I have 100 tables and i need to create insert and delete trigger.

Thanks in advance.

Rohit

t-sql sql-server-2012 dynamic-sql triggers

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM commented · Mar 08, 2019 at 01:08 PM

What have you tried thus far?

0 ·

Answer 1 · 2019-03-08T13:32:05Z

tiwaryrohit143 answered Mar 8, '19

I have written for insert/update trigger. You can check the script attached. I will shortly write for delete. This will be helpful.

create-triger-dynamic.txt (4.8 KiB)

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.