title: Create SQL INSERT Script with values gathered from table
body: <p>I need to create a INSERT script in order to insert in another database the same data.<br/> If in SQL Server I select "Script table as > INSERT To" I can easily recreate the skeleton for the INSERT statement. However since I have several records to migrate, I would prefer to avoid having to insert the values manually.</p>
  
  <p><strong>Therefore is there any way to "automatically" get the INSERT script with also the values (coming from the target table) filled in?</strong> </p>
  
  <p>I know this could be done with SSIS, but I am wondering whether it would be possible as well with a quicker solution.</p>