How do I insert multiple rows WITHOUT repeating the “INSERT INTO"

Question

Hello,

I want insert many Data in my table (for example 500 Rows) and i don't repeating "Insert to".

How exist script for it?

Thank you

Answer 1

Hello,

Since SQL Server 2008 insert statements with multiple rows value are support; for example this script insert 3 rows, seprated by a comma:

INSERT INTO myTable (col1, col2)
VALUES ('val01', 'val02') ,
       ('val11', 'val12') ,
       ('val21', 'val22') 

---

Olaf Helper

Blog Xing

Answer 2

What is your data source?

You can use a INSERT INTO ... SELECT if your source is another Table.

for example:

INSERT INTO dbo.DestinationTable
SELECT * FROM dbo.SourceTable

---

- Vishal

SqlAndMe.com