---
title: "Discussion on \"Trick to get large data in SQL Management Studio\" | Hashnode"
description: "Discussion on \"Trick to get large data in SQL Management Studio\". If you have a column with long text, you can cast it to XML and get it out. Here is an example where the text is so big that it is also compressed.\nSELECT \nconvert(xml,'<![CDATA[‘ + cast(decompress(longTextColumn) as nvarchar(max)) + ‘]]>’) as LongTe..."
url: "https://hashnode.com/posts/trick-to-get-large-data-in-sql-management-studio/603542b40dde8f7722d1e561"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Trick to get large data in SQL Management Studio](https://cwizsoftware.com/trick-to-get-large-data-in-sql-management-studio?utm_source=hashnode&utm_medium=feed)

If you have a column with long text, you can cast it to XML and get it out. Here is an example where the text is so big that it is also compressed. SELECT convert(xml,'<!\[CDATA\[‘ + cast(decompress(longTextColumn) as nvarchar(max)) + ‘\]\]>’) as LongTe...

Aug 23, 2017 · 1 min read · cwizsoftware.com  
Read the article

-   [#sql-server](https://hashnode.com/tag/sql-server)

## Written by

[Xavier](https://hashnode.com/@xavier2021)

@xavier2021

  
[View profile](https://hashnode.com/@xavier2021)

C#

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
