title: How to get SQL Server query result's data into JSON Format ?
body: <p>I'm just getting to understand Ajax and JSON format.  I'm building a very simple address book.
  So assume I have a table with for sake of simplicity has 3 columns:</p>
  
  <p><code>Name, Email and Phone</code></p>
  
  <p>My javascript / jquery is not the best just learning, but I want to put the data returned from my SQL Server into JSON format.  Should I create a stored procedure that can create a json file and put it in a folder where I can use it in my javascript?</p>
  
  <p>Or is this something like a client C# / VB.net app should be doing where it actually generates the file every say 5 minutes?  Basically lets assume I get some data back:</p>
  
  <pre><code>George g@yahoo.com 123-3333
  Mike m@gmail.com 123-4433
  Steve s@gmail.com 144-3333
  Jill r@gmail.com 333-3333
  </code></pre>
  
  <p>I get this back from a simple select statement:</p>
  
  <p><code>SELECT name, email, phone from myTable</code></p>
  
  <p>How can I then get this as a json file so I can store the data in a <code>.json</code> and then use that file in my javascript code.  Can someone explain this as well as how people generate json files?</p>