Object type: User defined function

Scalar function used in the uSalesOrderHeader trigger to set the starting account date.

Syntax

dbo.ufnGetAccountingEndDate ( )

Properties 

Output data type	Transactional	Uses cursors	Executes procedures	Dynamic content	Encrypted
datetime	No	No	No	No	No

Calling triggers 

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

Applies to

Functions | Scalar

The AdventureWorks database sample was developed by Microsoft Corporation, copyright 2005. SQL Server is a trademark of Microsoft Corporation