Triggers | SQL 2005 Adventure Works OLTP |
AFTER UPDATE trigger setting the ModifiedDate column in the BillOfMaterials table to the current date.
Summary
On table: Delete Update Insert Type Production.BillOfMaterials No Yes Yes After
Properties
Modifies data Transactional Uses cursors Executes procedures Dynamic content Encrypted Yes No No No No No
Data Source Activity
Modifications Description Production.BillOfMaterials Items required to make bicycles and bicycle subassemblies. It identifies the heirarchical relationship between a parent product and its components.
Applies to
Triggers | Modifies data | On update | After table changes