How do you view ALL text from an ntext or nvarchar(max) in SSMS?

by

I was able to get the full text (99,208 chars) out of a NVARCHAR(MAX) column by selecting (Results To Grid) just that column and then right-clicking on it and then saving the result as a CSV file. To view the result open the CSV file with a text editor (NOT Excel). Funny enough, when I tried to run the same query, but having Results to File enabled, the output was truncated using the Results to Text limit.

The work-around that @MartinSmith described as a comment to the (currently) accepted answer didn’t work for me (got an error when trying to view the full XML result complaining about “The ‘[‘ character, hexadecimal value 0x5B, cannot be included in a name”).

More Related Contents:

  1. Comma separated results in SQL
  2. How to check if a column exists in a SQL Server table
  3. Understanding PIVOT function in T-SQL
  4. Using T-SQL, return nth delimited element from a string
  5. Get first day of week in SQL Server
  6. What is the use of GO in SQL Server Management Studio & Transact SQL?
  7. Confused about UPDLOCK, HOLDLOCK
  8. How do I view the full content of a text or varchar(MAX) column in SQL Server 2008 Management Studio?
  9. INSERT INTO vs SELECT INTO
  10. SQL Server 2008 Empty String vs. Space
  11. How to set a default value for an existing column
  12. How can I automate the “generate scripts” task in SQL Server Management Studio 2008?
  13. Select / Insert version of an Upsert: is there a design pattern for high concurrency?
  14. Query times out when executed from web, but super-fast when executed from SSMS
  15. TSQL: How to convert local time to UTC? (SQL Server 2008)
  16. Unique constraint on multiple columns
  17. SQL Server: combining multiple rows into one row
  18. How do I find a stored procedure containing ?
  19. SQL Recursive CTE: Finding objects linked by property
  20. How to convert number of minutes to hh:mm format in TSQL?
  21. Convert decimal time to hours and minutes
  22. SQL Server 2008 – How do i return a User-Defined Table Type from a Table-Valued Function?
  23. How do I move a table into a schema in T-SQL
  24. The request failed or the service did not respond in a timely fashion?
  25. Instead of trigger in SQL Server loses SCOPE_IDENTITY?
  26. FOR JSON PATH results in SSMS truncated to 2033 characters
  27. How Can I Detect and Bound Changes Between Row Values in a SQL Table?
  28. How to wait for 2 seconds?
  29. What are row, page and table locks? And when they are acquired?
  30. Generate MD5 hash string with T-SQL

Leave a Comment