Unable to copy large column containing JSON data from result of select query

Question

I have one table TreeVersions in SQL Server which has one JSONTree column having large tree JSON data.

Now I have run select JSONTree from dbo.TreeVersions where Tree_Id=1, I get result for tree 1. But when I copy the JSONTree column from the result, it does not get me the full result.

Can anyone tell me what query I need to get the full result or what I need to do to get the full data of this column? Thanks!

Answer 1

Possible duplicate of How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?

The answer there : https://stackoverflow.com/a/36362262/2089232 should help you:

SELECT CAST('<![CDATA[' + LargeTextColumn + ']]>' AS XML) FROM TableName;