Database reference - AdventureWorks2008

AdventureWorks2008 -  functions

function overview

name created modified code length dependents depends on inline deterministic schema bound comment
ufnGetAccountingEndDate Mar 19 2009 9:10PM Mar 19 2009 9:10PM 166 0 0 no no no Scalar function used in the uSalesOrderHeader trigger to set the starting account date. 
ufnGetAccountingStartDate Mar 19 2009 9:10PM Mar 19 2009 9:10PM 142 0 0 no no no Scalar function used in the uSalesOrderHeader trigger to set the ending account date. 
ufnGetContactInformation Mar 19 2009 9:10PM Mar 19 2009 9:10PM 2,851 0 7 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:10PM Mar 19 2009 9:10PM 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:10PM Mar 19 2009 9:10PM 763 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:10PM Mar 19 2009 9:10PM 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:10PM Mar 19 2009 9:10PM 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:10PM Mar 19 2009 9:10PM 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:10PM Mar 19 2009 9:10PM 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:10PM Mar 19 2009 9:10PM 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:09PM Mar 19 2009 9:09PM 332 1 0 no yes yes Scalar function used by the Sales.Customer table to help set the account number. 


Largest functions by code length



Documentation generated by SqlSpec