Compress and Decompress stored procedures for SQL Server 7.0, 2000, 2005

Important note

These procedures have been recently moved to a new xpFileUtils library.

Overview

This adds 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.