Insert 1000 rows in three tables at the same time

Question

Question by Yazle · Oct 21, 2019 at 12:35 PM · sql-server-2012 sql server database insert table

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 ?

0 Show 1

10 |1200 characters needed characters left characters exceeded

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

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

Share

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?

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

Answer by Yazle · Oct 22, 2019 at 12:01 PM

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

0 Show 2 · Share

10 |1200 characters needed characters left characters exceeded

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

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

Share

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

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

Share

Yeah I need to generate the data @JohnM

Insert 1000 rows in three tables at the same time

1 Reply

Your answer

Follow this Question

Related Questions