Fetch Long Text in SSMS Query Editor
Jan 2, 2021
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)]
