Invoking trigger on dml event

Asked By philippe so 20 points N/A Posted on - 03/13/2012

If I use a hardware/software: sql server 2008, How do I invoke the trigger on dml particular record?

• Status: Open
• Question Views: 964
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: File Servers

Answered By Emon Asejo 0 points N/A #103368

Invoking trigger on dml event

Hello Philippe So, after CREATE table and giving tablename, entity their type and no. of characters(width) etc, CREATE TRIGGER and AFTER INSERT AS and INSERT some data into the created table. Now simply suppose you have created the trigger to fire on deletion of multiple rows. By simply using DELETE trigger for the multiple records. This is how the trigger invokes when you SET it on the event you what to tackle with the manageable way.

Hope this helps you a bit and if you could provide the details about the trigger for the event might help you with full ease.

About Emon Asejo

Questions
2

Answers
18

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 03/13/2012
• Question Category: File Servers