DECOMPRESS (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2016)yesAzure SQL DatabasenoAzure SQL Data Warehouse noParallel Data Warehouse

Decompress input expression using GZIP algorithm. Result of the compression is byte array (VARBINARY(MAX) type).

Topic link icon Transact-SQL Syntax Conventions

Syntax

DECOMPRESS ( expression )  

Arguments

expression
Is a varbinary(n), varbinary(max), or binary(n). For more information, see Expressions (Transact-SQL).

Return Types

Returns the data type of varbinary(max) type. The input argument is decompressed using the ZIP algorithm. The user should explicitly cast result to a target type if needed.

Remarks

Examples

A. Decompress Data at Query Time

The following example shows how to show compress data from a table:

SELECT _id, name, surname, datemodified,  
             CAST(DECOMPRESS(info) AS NVARCHAR(MAX)) AS info  
FROM player;  

B. Display Compressed Data Using Computed Column

The following example shows how to create a table to store decompressed data:

CREATE TABLE (  
    _id int primary key identity,  
    name nvarchar(max),  
    surname nvarchar(max),  
    info varbinary(max),  
    info_json as CAST(decompress(info) as nvarchar(max))  
);  

See Also

String Functions (Transact-SQL)
COMPRESS (Transact-SQL)