Triggers

[simar]

What the use of triggers????????????????????????

[ProgrammerGuy]

A trigger is a piece of code that executes when a particular event happens on a table or view. It is generally used to maintain integrity within a database, such as if you delete a stock item from the stock table then all the pricing breaks from the pricing table are removed for that item.

[simar]

Thanks for sharing information.

[vincebeny]

A database trigger is procedural code that is automatically executed in response to certain events on a particular table or view in a database..But,how does these work??

[Christina_Willi]

A trigger is a named database object that is associated with a table and that is activated when a particular event occurs for the table.

[host56]

You can use triggers to perform the following actions, as well as others that are not found in this list:

1.Create an audit trail of activity in the database. For example, you can track updates to the orders table by updating corroborating information to an audit table.
2.Implement a business rule. For example, you can determine when an order exceeds a customer's credit limit and display a message to that effect.
3.Derive additional data that is not available within a table or within the database. For example, when an update occurs to the quantity column of the items table, you can calculate the corresponding adjustment to the total_price column.
4.Enforce referential integrity. When you delete a customer, for example, you can use a trigger to delete corresponding rows (that is, rows that have the same customer number) in the orders table.



Restylane Injections

[niharikadutt]

A trigger is a piece of code that executes when a particular event happens on a table or view. It is generally used to maintain integrity within a database, such as if you delete a stock item from the stock table then all the pricing breaks from the pricing table are removed for that item.

nice answer.

[melvinscott92]

Triggers are a database operations that are automatically performed that are particular event occurs. A Triggers may be particular to fire whenever a delete,insert or update of a particular database table occurs.

[jameskamroon1]

SQL Server Books Online states that "triggers are a special class of stored procedure defined to execute automatically when an UPDATE, INSERT or DELETE statement is issued against a table or view." The problem with triggers is that they cannot be "seen."

[mariaandreson]

In a DBMS, a trigger is a procedure that initiates an action (i.e., fires an action) when an event (INSERT, DELETE or UPDATE) occurs.

[aidpcards]

Triggers are automatic procedures used to alert when an insert,update or delete operation is done against the table or view.