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

From dbscript Online Help
Jump to: navigation, search
(New page: == wikibot == {| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse" |- | '''function | dbo.ufnGetAccountingStartDate |- |} <pre> CREATE FUNCTION [dbo].[ufnGetAcc...)
 
Line 16: Line 16:
 
END;
 
END;
 
</pre>
 
</pre>
 +
 +
== automatically generated ==
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|-
 +
| '''function
 +
| dbo.ufnGetAccountingStartDate
 +
|-
 +
 +
| '''Description
 +
| Scalar function used in the uSalesOrderHeader trigger to set the ending account date.
 +
|-
 +
 +
|}
 +
 +
<pre>
 +
 +
CREATE FUNCTION [dbo].[ufnGetAccountingStartDate]()
 +
RETURNS [datetime]
 +
AS
 +
BEGIN
 +
    RETURN CONVERT(datetime, '20030701', 112);
 +
END;
 +
</pre>
 +
 +
 +
{| border="1" cellpadding="5" cellspacing="0" style="border-collapse:collapse"
 +
|- style="background:silver"
 +
| '''Referencing Object
 +
| '''Object Type
 +
| '''Reference Type
 +
 +
|-
 +
| [[Sales.SalesOrderHeader_(table)|Sales.SalesOrderHeader]]
 +
| Table
 +
| Execute
 +
|}

Revision as of 23:59, 26 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;


Referencing Object Object Type Reference Type
Sales.SalesOrderHeader Table Execute