ntext in a temporary table
Posted on 2014-02-24
I have an XML string that is stored as an ntext column on a 3rd party DB. When running a query against that DB I'm putting some values into a temporary table.
select <col1>, <col2> ... into #temp from myTable
when I do a select * from #temp, I'm noticing that my XML column doesn't return the full string. However select max(len(myXml)) from #temp returns it's invalid for an ntext type. How do I see / get the full XML of this when it's passed 8000 characters?