title: How to export data from SQL Server database
body: <p>Please can someone tell me how I can easily export data from a SQL Server 2012 database? I have been trying for a while now and have read several articles but I either do not understand them or they are not what I am looking for.</p>
  
  <p>I want to export ONLY the data itself to a single <code>.sql</code> file, is this possible and if so can somebody please tell me how I can do this?</p>
  
  <p>I expect the code to be generated as <code>insert</code> statements eg.</p>
  
  <pre><code>insert into employee(id, name, address) 
  values('1', 'Yao Ming', 'No.2 NBA Street');
  </code></pre>