This site will work and look better in a browser that supports web standards, but it is accessible to any browser or Internet device.

CleanCode logo
sitemap
SEARCH:
NAVIGATION: first page in sectionnext pagefinal page in section

SQL Functions and Procedures

StoredProcedures

Histogram: generates dynamic histogram result sets
Map: maps a list to an arbitrary DML statement
SP_map: [deprecated] maps a list to an arbitrary DML statement

NB: As of version 0.9.22 (2008.06.01), SP_map was renamed Map.

Functions

BoundSmoothing: smooths numerical boundaries to round lots
GetDataTypeName: returns the data type of a field
list2table: Convert a list to a table
list2tableIndexed: Convert a list to a table with array indexing

NB: As of version 0.9.22 (2008.06.01), FN_list2table and FN_list2tableIndexed were renamed to list2table and list2tableIndexed respectively.

Also, don't miss the C#, Java, JavaScript, and Perl libraries and tools.

This documentation set was created with the CleanCode documentation generator (XmlTransform and sqldoc2xml). For details on how this documentation set was generated--and to learn how to apply it to your own libraries--see my two articles on the DevX online magazine: Add Custom XML Documentation Capability To Your SQL Code and XmlTransform:A General-Purpose XSLT Pre-Processor.

This library was developed with SQL Server 2000, SQL Server 2005 Express, SQL Server Management Studio Express, Vim, Ant 1.7, and SubVersion.

Get CleanCode at SourceForge.net. Fast, secure and Free Open Source software downloads
Copyright © 2001-2009 Michael Sorens • Contact us • Privacy Policy
Usage governed by Mozilla Public License 1.1 and CleanCode Courtesy License
CleanCode -- The Website for Clean DesignRevised 2009.10.31