Hi,
I want to know that what is the role of of Triggers in database and how can i implement it?
Thanks
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Jignesh TrivediPosted Jan 25, 2012, 1:46 AM
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 KumarPosted Jan 24, 2012, 11:13 PM
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