title: Converting Select results into Insert script - SQL Server
body: <p>I have <code>SQL Server 2008</code>, SQL Server Management Studio.</p>
  
  <p>I need to select data from <code>Table1</code> in database1. Then I have to edit some values in the results and <code>insert values into Table1</code> in database2. </p>
  
  <p>Or let me put it other way. </p>
  
  <p>How can I convert the data in one table into <code>insert script</code>.</p>