dcsimg
LinkedIn
Twitter
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX


advertisement
 

Tip: Compress and Decompress SQL Functions

Learn how to compress and decompress data in SQL.


advertisement

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)

 

Visit the DevX Tip Bank

 



   
Email AuthorEmail Author
Close Icon
Thanks for your registration, follow us on our social networks to keep up-to-date