SQL Server 2008 – Auto Generate Insert Statement

This is very quick way to generate the Insert Statement for all of the data in your table. This is really very useful feature of SQL Server

Summary:

Right click on the database and go to Tasks -> Generate Scripts
Select the tables for that you want to generate the script
Click on the Advanced button.
In the General category, go to Type of data to script. There are 3 options: Schema Only, Data Only, and Schema and Data. Select the Data Only or Schema and Data according to your requirement.
Your script will be ready