Difference between revisions of "Dbo.ufnGetAccountingStartDate (function)"

From dbscript Online Help
Jump to: navigation, search
Line 23: Line 23:
 
| dbo.ufnGetAccountingStartDate
 
| dbo.ufnGetAccountingStartDate
 
|- valign="top"
 
|- valign="top"
 
 
| '''Description
 
| '''Description
 
| Scalar function used in the uSalesOrderHeader trigger to set the ending account date.
 
| Scalar function used in the uSalesOrderHeader trigger to set the ending account date.
 
|-
 
|-
 
 
|}
 
|}
  

Revision as of 08:01, 30 November 2009

wikibot

function dbo.ufnGetAccountingStartDate
CREATE FUNCTION [dbo].[ufnGetAccountingStartDate]()
RETURNS [datetime] 
AS 
BEGIN
    RETURN CONVERT(datetime, '20030701', 112);
END;

automatically generated

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

CREATE FUNCTION [dbo].[ufnGetAccountingStartDate]()
RETURNS [datetime] 
AS 
BEGIN
    RETURN CONVERT(datetime, '20030701', 112);
END;


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