what is trigger

Question

what is trigger and how to work it with example

Gowtham K · Answer

Refer this, http://www.codeproject.com/Articles/25600/Triggers-SQL-Server This is the one of the best example for triggers

Arul R · Answer

Creates a DML, DDL, or logon trigger. A trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server. DML triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view. These triggers fire when any valid event is fired, regardless of whether or not any table rows are affected. http://www.c-sharpcorner.com/UploadFile/37db1d/creating-and-managing-triggers-in-sql-server-20052008/ https://msdn.microsoft.com/en-IN/library/ms189799.aspx http://www.codeproject.com/Articles/25600/Triggers-SQL-Server https://www.mssqltips.com/sqlservertutorial/2911/working-with-triggers/ Let me know for any thing more.... If your problem solved means kindly Accept my answer

Prakash Tripathi · Answer

Trigger as the name suggests are DB objects which gets invoked against DB operation like Insert/Update/Delete. In most cases, we create trigger on DML operations (Insert/Update/Delete) however we can also create DDL trigger for example Login trigger. DDL triggers are mostly used by administrators. Hope this answers. Please let me know if you have any other question related to trigger. If you find this useful, please close the thread by accepting it.

Manas Mohapatra · Answer

Triggers are database objects which executes if any DML operations(Insert, update, delete) occurs in any objects(tables) in database. Let's take an example there is a Employee table where employees salary is stored. The employee go promotion and salary is hiked. We need to update the salary column value of respective employee. Suppose we want to see the employee salary history then how can we implement. Just create a trigger on Employee table on update and store the old and new value in Employee_Salary_History table. Please go through below links: https://www.mssqltips.com/sqlservertutorial/2911/working-with-triggers/ http://www.sqlteam.com/article/an-introduction-to-triggers-part-i http://www.codeproject.com/Articles/25600/Triggers-SQL-Server

what is trigger

Answers (4)