Navigation Menu

Skip to content

Instantly share code, notes, and snippets.

@samirbehara-zz

samirbehara-zz/Compress Decompress in SQL Server 2016

Created October 30, 2017 04:28
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save samirbehara-zz/8977fc579a56d6c51f626a5d60ccdded to your computer and use it in GitHub Desktop.
Save samirbehara-zz/8977fc579a56d6c51f626a5d60ccdded to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Compress Decompress in SQL Server 2016
--Demonstration of COMPRESS and DECOMPRESS Features
SELECT COMPRESS ('New Features of SQL Server 2016')
SELECT CAST(DECOMPRESS(0x1F8B0800000000000400F34B2D57704B4D2C292D4A2D56C84F53080EF451084E2D2A4B2D52303230340300FD90F96A1F000000) AS VARCHAR(MAX))
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment