Dbo.ufnGetAccountingEndDate (function)

From dbscript Online Help
Revision as of 22:59, 23 June 2010 by Bot (talk | contribs)
Jump to: navigation, search

wikibot

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

Source

CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]()
RETURNS [datetime] 
AS 
BEGIN
    RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112));
END;

Dependencies

Reference Type Object Type Referencing Object Child Type Child Object
Execute Table Sales.SalesOrderHeader Trigger uSalesOrderHeader


automatically generated

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

CREATE FUNCTION [dbo].[ufnGetAccountingEndDate]()
RETURNS [datetime] 
AS 
BEGIN
    RETURN DATEADD(millisecond, -2, CONVERT(datetime, '20040701', 112));
END;


Reference Type Object Type Referencing Object Child Type Child Object
Execute Table Sales.SalesOrderHeader Trigger uSalesOrderHeader