Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Jeff Moden Display More Than 8000 Characters (SQL Spackle) RE: Display More Than 8000 Characters (SQL Spackle)

  • June 28, 2013 at 4:02 pm

    #1628439

    Here's a very quick and easy way to display all characters that I did not see here.

    select convert(xml,'<txt>' + @txt + '</txt>')

    In SSMS, it returns a link that opens a new tab with all of the text.