when will you use triggers? and where we use triggers? [Resolved]

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/UploadFile/63f5c2/triggers-in-sql-server/

http://www.codeproject.com/Articles/38808/Overview-of-SQL-Server-database-Triggers

http://www.c-sharpcorner.com/Blogs/5315/trigger-in-sql-server.aspx

Thanks
-Raja

Chamu, if this helps please login to Mark As Answer. | Alert Moderator

Thanks

Chamu, if this helps please login to Mark As Answer. | Alert Moderator

Also you can refer http://www.dotnet-tricks.com/Tutorial/sqlserver/OJ97170312-Different-Types-of-SQL-Server-Triggers.html

--
Thanks & Regards,
RNA Team

Chamu, if this helps please login to Mark As Answer. | Alert Moderator

you are most Welcome @Chamu

Thanks
-Raja

Chamu, if this helps please login to Mark As Answer. | Alert Moderator