Auto Generate Insert Script In SQL Server 2008
In this article I tell you how to generate insert script for a table in SQL Server.
In this article I tell you how to generate insert script for a table in SQL Server.
There is a very quick way to generate Insert script for the table data. Follow given steps to generate script:
Step 1
Right-Click on database for that you want to generate the script. Go to Tasks-> Generate Scripts.
Step 2
Select the table whose script you want to generate and click Next.
Step 3
Select location where you want to save generated script. Suppose I select 'Save to New Query Window'. Go to Advanced Button.
Step 4
In the General category, go to Type of data to script and select Data only. You can choose any of 3 option according to your requirement and Click Next upto script is generated.
Step 5
Click Finish to close window.
