Converting Select results into Insert script - SQL Server [closed]

Question

I have SQL Server 2008, SQL Server Management Studio.

I need to select data from Table1 in database1. Then I have to edit some values in the results and insert values into Table1 in database2.

Or let me put it other way.

How can I convert the data in one table into insert script.

Answer 1

Here is another method, which may be easier than installing plugins or external tools in some situations:

• Do a select [whatever you need]INTO temp.table_namefrom [... etc ...].
• Right-click on the database in the Object Explorer => Tasks => Generate Scripts
• Select temp.table_name in the "Choose Objects" screen, click Next.
• In the "Specify how scripts should be saved" screen:
  • Click Advanced, find the "Types of data to Script" property, select "Data only", close the advanced properties.
  • Select "Save to new query window" (unless you have thousands of records).
• Click Next, wait for the job to complete, observe the resulting INSERT statements appear in a new query window.
• Use Find & Replace to change all [temp.table_name] to [your_table_name].
• drop table [temp.table_name].

Answer 2

In SSMS:

• Right click on the database > Tasks > Generate Scripts

• Next

• Select "Select specific database objects" and check the table you want scripted, Next

• Click Advanced > in the list of options, scroll down to the bottom and look for the "Types of data to script" and change it to "Data Only" > OK

• Select "Save to new query window" > Next > Next > Finish

All 180 rows now written as 180 insert statements!