Role of Triggers in Database

Question

Hi I want to know that what is the role of of Triggers in database and how can i implement it? Thanks

Jignesh Trivedi · Answer

hi A trigger is a database object that is attached to a table. In many aspects it is similar to a stored procedure. As a matter of fact triggers are often referred to as a  special kind of stored procedure . The main difference between a trigger and a stored procedure is that the former is attached to a table and is only fired when an INSERT UPDATE or DELETE occurs. You specify the modification action(s) that fire the trigger when it is created. please refer http://msdn.microsoft.com/en-us/library/aa258254%28v=sql.80%29.aspx hope this help.

Mukesh Kumar · Answer

Hi Deepak Please refer these links : http://www.codeproject.com/Articles/7304/Brief-about-Triggers-in-SQL-Server-2000 http://msdn.microsoft.com/en-us/library/ms189799.aspx