Trigger

Question

Hello;

Please help me to understand me use of trigger. I just need some real life examples , so that I can understand when I can use triggers? Please give me 3-4 situations where we use it?

Thanks in advance..

pritaeas · Answer

Here's one: Assume you want to create an audit trail of all changes made to your company table. By using triggers you can create a history table automatically. An insert trigger can log the creation of a new company an update trigger can detect and log individual column changes. Once implemented it will automatically log all changes made to your company table separately whether it's from code or when you change something directly in the database using a SQL query. You will have a complete viewable history of changes.

Khan Abrar Ahmed · Answer

HI check this posts https://msdn.microsoft.com/en-us/library/ms189799.aspx http://www.sqlteam.com/article/an-introduction-to-triggers-part-i https://en.wikipedia.org/wiki/Database_trigger