Object type: Trigger

AFTER UPDATE trigger that updates the RevisionNumber and ModifiedDate columns in the SalesOrderHeader table.Updates the SalesYTD column in the SalesPerson and SalesTerritory tables.

Summary 

On table:	Delete	Update	Insert	Type
Sales.SalesOrderHeader	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.SalesOrderHeader	General sales order information.
Sales.SalesPerson	Sales representative current information.
Sales.SalesTerritory	Sales territory lookup table.

Accesses	Description
Sales.SalesOrderHeader	General sales order information.

Called functions 

Name	Description
dbo.ufnGetAccountingEndDate	Scalar function used in the uSalesOrderHeader trigger to set the starting account date.
dbo.ufnGetAccountingStartDate	Scalar function used in the uSalesOrderHeader trigger to set the ending account date.

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