Triggers | SQL 2005 Adventure Works OLTP |
AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the PurchaseOrderHeader table.
Summary
On table: Delete Update Insert Type Purchasing.PurchaseOrderHeader 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 Purchasing.PurchaseOrderHeader General purchase order information. See PurchaseOrderDetail.
Applies to
Triggers | Modifies data | Transactional | On update | After table changes