Thread: What is trigger?

I know that A trigger is a special kind of stored procedure that is invoked whenever an attempt is made to modify the data in the table it protects. Modifications to the table are made ussing INSERT,UPDATE,OR DELETE statements.

For example, if you have a table with a field that contains the date this record has been modified, you could set a trigger on updates and inserts that will set this field to the current date so you wont have to handle this field in your application code.

Triggers are used to enforce data integrity and business rules such as automatically updating summary data. It allows to perform cascading delete or update operations. If constraints exist on the trigger table,they are checked prior to the trigger execution. If constraints are violated statement will not be executed and trigger will not run.Triggers are associated with tables and they are automatic . Triggers are automatically invoked by SQL SERVER. Triggers prevent incorrect , unauthorized,or inconsistent changes to data.

Triggers are programs that execute in acknowledgment to changes in table abstracts or assertive database events. There is a predefined set of contest that can be "hooked" with a trigger, enabling you to accommodate your own processing with that of the database.

Triggers are the programs that is used to store the procedure.. Trigger is part of mysql...

Trigger is a SQL procedure that initiates an action, when an event (INSERT, DELETE or UPDATE) occurs.

Tigger is a PL/SQL Block and get executed when any DML operation Performed like Insert Delete and Update

Nice! Thanks for sharing this post.Keep posting these type of informative post.

trigger is program that fair automatically.

u defined too good but it is not satisfactory..............

Activates can be considered as just like saved techniques in that both contain step-by-step reasoning that is saved at the data source level. Stored techniques, however, are not event-drive and are not connected to a particular desk as triggers are. Stored techniques are clearly implemented by invoking a CALL to the process while triggers are unquestioningly implemented. Moreover, triggers can also perform saved techniques.

trigger is a procedural code which executes in response to events occured on table or view like insert, update, deletion of records from table or similar events

Trigger is a predefined event base procedure which are fires when some event occures. They are useful in events like log-in, log-off, insertion, deletion and updation in table.

It is a stored procedure that is invoked when we do insert, delete and update any record from the table.

Triggers are the programs that are fired \ initiates automatically when an event tooks place.They make positive changes in the program in order to make programm more easier.

Triggers are stored procedures that are fired automatically when a program runs.

A trigger is a set of SQL statements that automatically fires off an action when a specific operation occurs like data changing in table. Trigger is applied for DML statements in SQL server 2000/2005 A trigger consists of an event and an action.we only use them when we need to perform a certain action as a result of an INSERT, UPDATE or DELETE and ad hoc SQL is used.