Dbo.ufnGetAccountingEndDate (function)

From dbscript Online Help
Revision as of 23:56, 28 December 2009 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.
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


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