January 24, 2008

Add Custom XML Documentation Capability To Your SQL Code

f you’ve ever worked with sophisticated database systems or large applications you’ve probably accumulated sizable libraries of stored procedure code. Such libraries typically hold a few hundred stored procedures, ranging from perhaps a few hundred lines of code to thousands of lines?but only minimal documentation. That’s because existing database documentation

XmlTransform—A General-Purpose XSLT Pre-Processor

he general-purpose XML transformer and/or validator discussed here, named “XmlTransform” operates on an arbitrarily deep directory tree containing files you want to transform. As output it optionally generates multi-level indices and can even add navigational linkages. XmlTransform’s validation capability is reasonably straightforward; it lets you ensure that the set of