Compress and Decompress SQL Functions

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)
Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Related Posts