AdventureWorks - functions

function overview

name	created	modified	code length	dependents	depends on	inline	deterministic	schema bound	comment
ufnGetAccountingEndDate	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	166	0	0	no	no	no	Scalar function used in the uSalesOrderHeader trigger to set the starting account date.
ufnGetAccountingStartDate	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	142	0	0	no	no	no	Scalar function used in the uSalesOrderHeader trigger to set the ending account date.
ufnGetContactInformation	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	3,663	0	6	no	no	no	Table value function returning the first name, last name, job title and contact type for a given contact.
ufnGetDocumentStatusText	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	457	0	0	no	no	no	Scalar function returning the text representation of the Status column in the Document table.
ufnGetProductDealerPrice	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	759	0	2	no	no	no	Scalar function returning the dealer price for a given product on a particular order date.
ufnGetProductListPrice	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	576	0	2	no	no	no	Scalar function returning the list price for a given product on a particular order date.
ufnGetProductStandardCost	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	647	0	2	no	no	no	Scalar function returning the standard cost for a given product on a particular order date.
ufnGetPurchaseOrderStatusText	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	485	0	0	no	no	no	Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table.
ufnGetSalesOrderStatusText	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	560	0	0	no	no	no	Scalar function returning the text representation of the Status column in the SalesOrderHeader table.
ufnGetStock	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	481	0	1	no	no	no	Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.
ufnLeadingZeros	Mar 19 2009 9:08PM	Mar 19 2009 9:08PM	332	1	0	no	yes	yes	Scalar function used by the Sales.Customer table to help set the account number.