dcsimg
 

Compress and Decompress SQL Functions

Tuesday Nov 27th 2018 by Hannes Du Preez

Language: SQL, Expertise: Intermediate - Learn how to use compress and decompress in SQL Server 2016.

Compress: Compresses input data and returns the binary data of type VARBINARY(MAX)

Decompress: Decompresses compressed input binary data and returns the binary data of type VARBINARY(MAX)

Here is small example in SQL Server 2016:

SELECT COMPRESS ('Data To Compress')
SELECT DECOMPRESS (Binary Data To Decompress)
Home
Mobile Site | Full Site