#triggers in sql

Using Triggers In SQL

Often times you want some event to be triggered automatically when a certain action is performed on a SQL database.

For instance, you might want to create logs for every INSERT operation performed on a database table or you might want to add a tax percentage to an amount entered by a user before storing it in the database.

In such scenarios you have two options:

1) You can first insert data…