title: Extracting the data from SQL Server filtered by username
body: <p>I have a huge table <code>tableA</code> in my database. I have to extract the entries made into this <code>tableA</code> by <code>userA</code>.</p>
  
  <p>My aim is to append this data in one more server where we give the build.</p>
  
  <p>The query </p>
  
  <pre><code>select * 
  from tableA 
  where name = 'userA'
  </code></pre>
  
  <p>will give the select statements. But how to get the insert statements as a script, so that when I run in a new db, all the entries should be inserted into the new table?</p>
  
  <p>To conclude, I want to extract and give the script to a build person of all the records made by me as a script.</p>