title: SQL Server, How to generate an `INSERT` statement for the rows in an existing table?
body: <p>Is there a way to generate an <code>INSERT</code> statement for the rows in an existing table?</p>
  
  <p>I have a table in SQL Server 2008 with 150 rows. I am wondering if something like the following is possible to get from that table.</p>
  
  <pre><code>INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
  VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway'); 
  </code></pre>
  
  <p>The SQL script should include all the 150 rows to insert.</p>