XP Compress Utils description
XP Compress Utils - Compress and Decompress stored procedures for SQL Server 7.0 - 2000

XP Compress Utils will add to T-SQL capabilities to compress and decompress custom data using LZ compression algorithm.

There are the following extended stored procedures:
· xp_ZCreate begins the work;
· xp_ZAppend adds data to be compressed/decompressed to an internal buffer;
· xp_ZCompress compresses data and returns the result as a single row recordset of SQL IMAGE datatype;
· xp_ZDecompress decompresses data previously compressed by xp_ZCompress, and returns the result as a single row recordset of SQL IMAGE datatype;
· xp_ZClose finishes the work.


These procedures are provided by a dynamic-link library, xpCompressUtils.DLL.