Functions | SQL 2005 Adventure Works OLTP |
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