Insert value into multiple tables using single insert query.

Logically it is not possible. But you can find different ways

If you are using SQLServer then:

https://stackoverflow.com/questions/10471757/insert-rows-into-multiple-tables-in-a-single-query-selecting-from-an-involved-t

or you can use MERGE statement, follow below link:

https://docs.microsoft.com/en-us/sql/t-sql/statements/merge-transact-sql

0

Create an STORE PROC, in this SP create insert statement for all table,

and while saving the data pass all records to SP and manage the data in SP inself.

+1

Hi Sandeep,

Will you please explain little more about your requirement.

0