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

SEARCH: NAVIGATION:

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.

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

ValidateStoredProcs: validates syntax and object references in stored procedures

Also, don't miss the PowerShell, 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/2005/2008, SQL Server Management Studio, SQL Search, Vim, Ant 1.7, and SubVersion.

CleanCode -- The Website for Clean DesignRevised 2013.06.30