Insert 1000 rows in three tables at the same time

Question

question

Yazle asked Oct 21, '19

Insert 1000 rows in three tables at the same time

Hi everyone,

I have three tables related to each other, I want to instert 1000 rows in each of them at the same time, and I dont want to write Insert 1000 times, what should I do ?

sql-server-2012 sql server database insert table

1

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM commented · Oct 22, 2019 at 11:56 AM

Well, that depends. The data you are inserting, is it in an existing table? or flat file? CSV? Do you really mean "exactly at the same time" or can it be done in the same transaction?

0 ·

Answer 1 · 2019-10-22T12:01:18Z

Yazle answered Oct 22, '19

Hi @JohnM, thank you. The insert would be on an existing table, and by ¨at the same time¨ I mean in the same transaction

2

10 |1200

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

JohnM commented · Oct 22, 2019 at 12:40 PM

Where is the data that you are inserting coming from? You can do a simple

INSERT dbo.Table1 (id, firstname, lastnam) SELECT id, firstname, lastname from dbo.Table2;

if the data is another table. If you need to randomly generate data, that's a different story

0 ·

Yazle commented · Oct 22, 2019 at 12:48 PM

Yeah I need to generate the data @JohnM

0 ·

question