Difference between revisions of "Dbo.ufnGetAccountingStartDate (function)"
(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 |