| Triggers | SQL 2005 Adventure Works OLTP |
AFTER INSERT, UPDATE trigger inserting Individual only if the Customer does not exist in the Store table and setting the ModifiedDate column in the Individual table to the current date.
Summary
On table: Delete Update Insert Type Sales.Individual No Yes Yes After
Properties
Modifies data Transactional Uses cursors Executes procedures Dynamic content Encrypted Yes Yes No No No No
Data Source Activity
Modifications Description Sales.Individual Demographic data about customers that purchase Adventure Works products online.
Accesses Description Sales.Store Customers (resellers) of Adventure Works products.
Applies to
Triggers | Modifies data | Transactional | On update | On insert | After table changes