Insert value into multiple tables using single insert query.

Question

Hi Is there any way to Insert value into multiple tables using single insert query with the help of joins if possible?

Manas Mohapatra · Answer

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

sudipta sanyal · Answer

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.

Vishwash Roy · Answer

Hi Sandeep Will you please explain little more about your requirement.