Best insert options.

[FISH786]

I have to check on a couple of things and was thinking of creating about 200million dummy records. I had a for loop and an insert statement in mind. Is there a faster way of creating and inserting such a mass volume of data into a database?

[PIEBALDconsult]

What database system? Does it have a bulk insert option? I often use a for or while loop and a parameterized insert statement.

[FISH786]

SQL Server.... Forgot about the bulk insert...I could use that with the for loop.

[ISoftwareDev]

Bulk inserts will probably be the fastest way. Have a look at: http://msdn.microsoft.com/en-us/library/ms188365.aspx[^]

[WoutL]

You cold use something like:

insert into table xxx
select '1', 3 , 'testdata'
from northwind..customers a, northwind..customers b, northwind..customers c

add more northwind x's to get more records. If you don't have the northwind database, any other (big) table on the sqlserver can be used.

Wout Louwers