#SQL Statements for rendering large text columns in SQL Server Management Studio
You've probably figured out that SQL Server Management Studio truncates long text columns in a query result. The SQL in this repository is helpful for tricking SSMS into displaying your long text columns as XML so that you can view the entire string.