SQL Server, How to generate an `INSERT` statement for the rows in an existing table?

Question

Is there a way to generate an INSERT statement for the rows in an existing table?

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.

INSERT INTO Customers (CustomerName, ContactName, Address, City, PostalCode, Country)
VALUES ('Cardinal', 'Tom B. Erichsen', 'Skagen 21', 'Stavanger', '4006', 'Norway');

The SQL script should include all the 150 rows to insert.

It sounds like you want to query the table, but you're inserting into it. The Insert statement looks sound. What are you actually hoping to do? — B. Clay Shannon-B. Crow Raven, Dec 08 '15 at 21:37
I believe he is trying to generate INSERT INTO statements for each row, perhaps to transfer data to another database? — Chet, Dec 08 '15 at 21:42

score 5 · Accepted Answer · answered Dec 08 '15 at 21:47

5

Here are the steps:-

Right click on your database in SSMS
Choose Tasks>Generate Scripts
Select specific database objects - choose the table you want to script. Click next
Select 'Save to new query window'. Click the 'Advanced button'
Change 'Types of data to script' to 'Data only'.
Click OK, Next, Next, Finish.

The query editor window should contain the script you need.

answered Dec 08 '15 at 21:47

Mat Richardson

3,576
4
31
56

Thanks @MatRichardson. This is exactely what I was looking for. – Yanov Adamsky Dec 08 '15 at 23:30

SQL Server, How to generate an `INSERT` statement for the rows in an existing table?

1 Answers1

Linked