Skip to content

Latest commit

 

History

History
81 lines (60 loc) · 2.38 KB

decompress-transact-sql.md

File metadata and controls

81 lines (60 loc) · 2.38 KB
title description author ms.author ms.reviewer ms.date ms.service ms.subservice ms.topic f1_keywords helpviewer_keywords dev_langs monikerRange
DECOMPRESS (Transact-SQL)
DECOMPRESS function decompresses an input expression value, using the Gzip algorithm.
markingmyname
maghan
randolphwest
03/09/2023
sql
t-sql
reference
DECOMPRESS
DECOMPRESS_TSQL
DECOMPRESS function
TSQL
= azuresqldb-current || = azuresqldb-mi-current || >= sql-server-2016 || >= sql-server-linux-2017 || = azuresqledge-current || = azure-sqldw-latest ||=fabric

DECOMPRESS (Transact-SQL)

[!INCLUDE sqlserver2016-asdb-asdbmi-asa-fabricse-fabricdw]

This function decompresses an input expression value, using the Gzip algorithm. DECOMPRESS returns a byte array in the varbinary(max) data type.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

DECOMPRESS ( expression )

Arguments

expression

A varbinary(n), varbinary(max), or binary(n) value. For more information, see Expressions (Transact-SQL).

Return types

A value of data type varbinary(max). DECOMPRESS uses the Gzip algorithm to decompress the input argument. You should explicitly cast the result to a target type if necessary.

Remarks

Examples

A. Decompress Data at Query Time

This example shows how to return compressed table data:

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

B. Display compressed data using computed column

Note

This example does not apply to Azure Synapse Analytics.

This example shows how to create a table for decompressed data storage:

CREATE TABLE example_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