AdventureWorks - functions

function overview

name	created	modified	code length	dependents	depends on	comment
[dbo].[Concatenate]	Aug 5 2006 5:06PM	Aug 5 2006 5:06PM	165	0	2	This is a very nifty aggregate function
[dbo].[ConvertCurrency]	Aug 5 2006 4:42PM	Aug 5 2006 4:42PM	0	0	3	this one is really something, isn't it?
[dbo].[fn_diagramobjects]	Jan 5 2008 7:23AM	Jan 5 2008 7:23AM	1,693	0	1
[dbo].[GetClrTypeName]	Aug 5 2006 5:05PM	Aug 5 2006 5:05PM	429	0	2
[dbo].[GetFields]	Aug 5 2006 5:05PM	Aug 5 2006 5:05PM	0	0	2
[dbo].[GetFullAssemblyName]	Aug 5 2006 5:05PM	Aug 5 2006 5:05PM	0	1	2
[dbo].[GetLoadedAssemblies]	Aug 5 2006 5:05PM	Aug 5 2006 5:05PM	0	0	2
[dbo].[GetMethods]	Aug 5 2006 5:05PM	Aug 5 2006 5:05PM	0	0	2
[dbo].[GetProperties]	Aug 5 2006 5:05PM	Aug 5 2006 5:05PM	0	0	2
[dbo].[GetTypes]	Aug 5 2006 5:05PM	Aug 5 2006 5:05PM	0	0	2
[dbo].[left_s]	Aug 5 2006 5:07PM	Aug 5 2006 5:07PM	0	0	2
[dbo].[len_s]	Aug 5 2006 5:07PM	Aug 5 2006 5:07PM	0	0	2
[dbo].[RegexMatches]	Aug 5 2006 5:06PM	Aug 5 2006 5:06PM	0	0	2
[dbo].[RegexReplace]	Aug 5 2006 5:06PM	Aug 5 2006 5:06PM	0	0	2
[dbo].[replace_s]	Aug 5 2006 5:07PM	Aug 5 2006 5:07PM	0	0	2
[dbo].[right_s]	Aug 5 2006 5:07PM	Aug 5 2006 5:07PM	0	0	2
[dbo].[Split]	Aug 5 2006 5:06PM	Aug 5 2006 5:06PM	0	0	2
[dbo].[sub_s]	Aug 5 2006 5:07PM	Aug 5 2006 5:07PM	0	0	2
[dbo].[ufnGetAccountingEndDate]	Oct 14 2005 2:00AM	Oct 14 2005 2:00AM	168	0	1	Scalar function used in the uSalesOrderHeader trigger to set the starting account date.
[dbo].[ufnGetAccountingStartDate]	Oct 14 2005 2:00AM	Oct 14 2005 2:00AM	120	0	1	Scalar function used in the uSalesOrderHeader trigger to set the ending account date.
[dbo].[ufnGetContactInformation]	Oct 14 2005 2:00AM	Oct 14 2005 2:00AM	3,665	0	7	Table value function returning the first name, last name, job title and contact type for a given contact.
[dbo].[ufnGetDocumentStatusText]	Oct 14 2005 2:00AM	Oct 14 2005 2:00AM	453	0	1	Scalar function returning the text representation of the Status column in the Document table.
[dbo].[ufnGetProductDealerPrice]	Oct 14 2005 2:00AM	Oct 14 2005 2:00AM	737	0	3	Scalar function returning the dealer price for a given product on a particular order date.
[dbo].[ufnGetProductListPrice]	Oct 14 2005 2:00AM	Oct 14 2005 2:00AM	554	0	3	Scalar function returning the list price for a given product on a particular order date.
[dbo].[ufnGetProductStandardCost]	Oct 14 2005 2:00AM	Oct 14 2005 2:00AM	625	0	3	Scalar function returning the standard cost for a given product on a particular order date.
[dbo].[ufnGetPurchaseOrderStatusText]	Oct 14 2005 2:00AM	Oct 14 2005 2:00AM	485	0	1	Scalar function returning the text representation of the Status column in the PurchaseOrderHeader table.
[dbo].[ufnGetSalesOrderStatusText]	Oct 14 2005 2:00AM	Oct 14 2005 2:00AM	560	0	1	Scalar function returning the text representation of the Status column in the SalesOrderHeader table.
[dbo].[ufnGetStock]	Oct 14 2005 2:00AM	Oct 14 2005 2:00AM	481	0	2	Scalar function returning the quantity of inventory in LocationID 6 (Miscellaneous Storage)for a specified ProductID.
[dbo].[ufnLeadingZeros]	Oct 14 2005 1:58AM	Oct 14 2005 1:58AM	332	1	1	Scalar function used by the Sales.Customer table to help set the account number.