Hi, A Trigger is a Database object just like a stored procedure or we can say it is a special kind of Stored Procedure which fires when an event occurs in a database.
Real time example trigger.
You have account in Bank.So your bank /personal details are is saved in Bank. If you want money withdraw money in ATM. Once get cash then get the message from bank for your mobile. How it is working? If u know tigger also know?
If you changed your account details at the tigger is fired so that you will get the message from bank.
More details check out below links
http://www.c-sharpcorner.com/Blogs/5315/trigger-in-sql-server.aspxChamu, if this helps please login to Mark As Answer. | Alert Moderator