No of visitors who read this post: 210
Category: File Servers
Type: Question
Author: Philippe so
No votes yet

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

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.

#

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.