devxlogo

Compress and Decompress SQL Functions

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)

devx-admin

Share the Post: