Triggers SQL 2005 Adventure Works OLTP

Production.uWorkOrder

Object type: Trigger

AFTER UPDATE trigger that inserts a row in the TransactionHistory table, updates ModifiedDate in the WorkOrder table.

Summary 

On table:  Delete  Update  Insert  Type 
Production.WorkOrder  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 
Production.TransactionHistory  Record of each purchase order, sales order, or work order transaction year to date. 
Production.WorkOrder  Manufacturing work orders. 

Applies to

Triggers | Modifies data | Transactional | On update | After table changes
The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation

Document was prepared on: Thursday, April 05, 2007
Help compiled by DBDocumentor, a Pikauba Software product. All rights reserved.