decompress-transact-sql.md

title	ms.custom	ms.date	ms.prod	ms.prod_service	ms.service	ms.component	ms.reviewer	ms.suite	ms.technology	ms.tgt_pltfrm	ms.topic	f1_keywords	helpviewer_keywords	ms.assetid	caps.latest.revision	author	ms.author	manager	ms.workload
DECOMPRESS (Transact-SQL) | Microsoft Docs		11/30/2015	sql-non-specified	database-engine, sql-database		t-sql|functions		sql	database-engine		language-reference	DECOMPRESS DECOMPRESS_TSQL	DECOMPRESS function	738d56be-3870-4774-b112-3dce27becc11	8	edmacauley	edmaca	cguyer	Inactive

DECOMPRESS (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2016-asdb-xxxx-xxx-md]

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

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)