Triggers | SQL 2005 Adventure Works OLTP |
AFTER INSERT, DELETE, UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in SalesOrderDetail and updates the SalesOrderHeader.SubTotal column.
Summary
On table: Delete Update Insert Type Sales.SalesOrderDetail Yes 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 Production.TransactionHistory Record of each purchase order, sales order, or work order transaction year to date. Sales.Individual Demographic data about customers that purchase Adventure Works products online. Sales.SalesOrderDetail Individual products associated with a specific sales order. See SalesOrderHeader. Sales.SalesOrderHeader General sales order information.
Accesses Description Sales.SalesOrderDetail Individual products associated with a specific sales order. See SalesOrderHeader. Sales.SalesOrderHeader General sales order information.
Applies to
Triggers | Modifies data | Transactional | On delete | On update | On insert | After table changes