SQL Trigger

Question

helo sir  can u explain me any1 eaisly DMLTrigger wth Example @ wht's the diff b/w after & instead of trigger Regard' Ashish Saxena

Vishal Gilbile · Answer

Hello Friend We make use of Instead of trigger for security purpose. For instance if you don't want that your particular table to be updated you could make use of instead of trigger to rollback the update statement fired against that table and provide user with a specific message that the table can't be updated. And talking from the point of view of after trigger it is used for updating or performing certain activity after an insertupdate or delete statement is fired against a particular table on which after trigger is put on. For instance if you want that after a record is deleted in a particular table let's say Emp that record copy to copied to a Table named as EmpBackup. This type of activity could be easily done by making use of After Trigger. For more information about the same kindly check the below link http://www.dotnet-tricks.com/Tutorial/sqlserver/OPUH170312-After-Trigger-Instead-of-Trigger-Example.html Hope that solves your problem. With Regards Vishal Gilbile.