title: SQL SERVER Export Json to File
body: <p>I want to export from sql server result json to 'json file'.</p>
  
  <p>Example:</p>
  
  <pre><code>SELECT * FROM SYS.all_columns FOR JSON AUTO
  </code></pre>
  
  <p>I know one method to do this using the command "BCP".</p>
  
  <p><strong>You are invited to share different ways to export 'Json File From Sql Server.'</strong></p>
  
  <p>(Example convert you can watch Here: <a href="https://stackoverflow.com/questions/54672995/how-to-convert-table-to-json-arrays">convert table to Json</a>)</p>