Fetch Long Text in SSMS Query Editor

When you try to get content of text data long than 43.600 characters in SQL Server Management Studio — Query Editor, SSMS trims text after 43.600th character.

If you want to see full content of column you can use this query:

SELECT YourColumnName as [processing-instruction(x)]

--

--