SoftadminUtil.Compression_Expand

 Show all Hide all
Not available in Cloud edition.

Expands data compressed with SoftadminUtil.Compression_Compress.

In SQL Server 2016 and higher you can use the built-in COMPRESS and DECOMPRESS functions instead. They are not compatible with the output of this function but provide an equivalent degree of compression.

Both the compressed and uncompressed data is held in the memory during expansion so usage on large blobs should be avoided.

Type: Scalar function
Area of use: General use

Return value: binary

Expanded data.

Parameters:

@Bytes mandatory binary
Data to be expanded.