title: sql server for json auto. How to get all of result
body: <p>When trying this: </p>
  
  <pre><code>select BtId, [Name], Type, ISNULL([Description], '') as [Description], 
  ISNULL(Comment, '') as Comment, ISNULL(Source, '') as Source, ISNULL(Info, '') as Info
  
  from BytegymType
  For json auto
  </code></pre>
  
  <p>I get this error message: </p>
  
  <pre><code>Unable to show XML. The following error happened:
  An error occurred while parsing EntityName. Line 1, position 14957.
  One solution is to increase the number of characters retrieved from the 
  server for XML data. To change this setting, on the Tools menu, click 
  Options.
  </code></pre>
  
  <p>I have set the sql result to max: </p>
  
  <p><a href="https://i.stack.imgur.com/cPtJo.png" rel="noreferrer"><img src="https://i.stack.imgur.com/cPtJo.png" alt="Microsoft SQL Server Management Studio 14.0.17289.0"></a></p>
  
  <p>The non-xml data i cant get over 655535 either..
  I tried also result to file, still missing stuff.</p>
  
  <p>Sorry I'm not too good with sql-server :(</p>