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.
  • 1804

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.

GenerateInsertScript01.jpg

Step 2

Select the table whose script you want to generate and click Next.

GenerateInsertScript02.jpg

Step 3

Select location where you want to save generated script. Suppose I select 'Save to New Query Window'. Go to Advanced Button.

GenerateInsertScript03.jpg

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.

GenerateInsertScript04.jpg

Step 5

Click Finish to close window.

GenerateInsertScript05.jpg

Categories

More Articles

© 2019 DotNetHeaven. All rights reserved.