title: SQL Server Management Studio show complete content of field varchar(max)
body: <p>There is a way in SQL Server Management Studio to read all the contents of a <code>varchar(max)</code> column when you run a select?</p>
  
  <p>I know that there is an option in <code>Options &gt; Query Execution &gt; SET TEXTSIZE</code>. But I was wondering if are something like when you have a XML file that you can click the cell and a new tab is open with the cell contents.</p>