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.

Copyright © 2001-2008 Michael Sorens • Contact us • Privacy Policy
Usage governed by Mozilla Public License 1.1 and CleanCode Courtesy License
CleanCode -- The Website for Clean DesignRevised 2008.05.31