<p>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.</p>
<pre><code>SELECT 
convert(xml,'&lt;![CDATA[‘ + cast(decompress(longTextColumn) as nvarchar(max)) + ‘]]&gt;’) as LongText
FROM [My].[TableWithLongText]
</code></pre>

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 LongText
FROM [My].[TableWithLongText]
``` 


Trick to get large data in SQL Management Studio