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. SELECT convert(xml,'<![CDATA[‘ + cast(decompress(longTextColumn) as nvarchar(max)) + ‘]]>’) as LongTe...