Use of Triggers ?

Question

Wt was d use of BEFORE & AFTER triggers ? And diff too... Thanks In Advance Dudes

Jignesh Trivedi · Answer

Hi, SQL Server has two type trigger After trigger and Instead Of Triggers(not Before Trigger). Name of trigger suggest itself their functionality. After trigger run after an insert, update or delete on a table. They are not supported for views. INSTEAD-OF triggers are very powerful objects in SQL Server. They allow the developer to divert the database engine to do something different than what the user is trying to do. An example of this would be to add an INSTEAD-OF trigger to any table in your database that rolls back transactions on tables that you do not want modified. You must be careful when using this method because the INSTEAD-OF trigger will need to be disabled before any specified modifications can occur to this table. hope this will help you.

Sandeep Singh Shekhawat · Answer

In SQL SERVER There are following types triggers 1. DDL Trigger 2.Login Trigger 3. DML Trigger i. AFTER Trigger a. INSERT b. DELETE c. UPDATE ii. INSTEAD OF Trigger a. INSERT b. DELETE c. UPDATE Now AFTER triggers are uses on table. which fire according to action or Data manuplation on table and perform operation. INSTEAD OF triggers are uses to on view which uses to INSERT/UPDATE/DELETE in tables using View that view contains more than one table.

suren v · Answer

Thanks fr U reply...

suren v · Answer

Hai satyapriya nayak...i knw dis all...thanks fr u reply...bt i want 2 knw exact diff BEFORE & AFTER triggers..u send link ly abt after trigger exp... wt abt before trigger?

Satyapriya Nayak · Answer

http://www.codeproject.com/Articles/25600/Triggers-Sql-Server http://www.c-sharpcorner.com/uploadfile/shashikantray/create-delete-and-update-triggers-in-a-database/default.aspx