How to Insert Multiple table data at same time?

Question

I hace 4 table in my database

1. Publisher Table

Attributes : ID (primary key,autoincrement) ,Name,City,Address,State

2 Author Table

Attributes : ID (primary key,autoincrement),Firstname,Lastname

3 Book Table

Attributes: ID(primary key,autoincrement),title,PublisherID (Foreign Key with Publisher ID)

4.Book_Author_MAP Table

Attributes: ID(primary key,autoincrement),BookID,AuthorID(Foreign Key with Author ID)

In all tables ID is only unique no one data is unique.

Now I have single form in ASP.net that takes input Publisher-> Name,City,Address,State,

Authors -> Firstname,Lastname,

Book -> Title

All the field will show on browser But when I submit the form I want to store all value in all table. But when firstly I save Publiser values but how can i find ID of publisher at that time because No one data in unique without ID and Book table ID attributes required publisher ID that time.How can I fetch ID of publisher.

Pankaj Kumar Choudhary · Answer

Read this blog for better understanding the Output Clause http://blog.sqlauthority.com/2007/10/01/sql-server-2005-output-clause-example-and-explanation-with-insert-update-delete/

Pankaj Kumar Choudhary · Answer

Hello! Neeraj For your query i think you must be use the stored procedure. in this stored procedure pass all the parameters that you required like NameCityAddressState FirstnameLastname title Now follow these steps. Step 1: Insert NameCityAddressState values in Publisher Table and Use OUTPUT clause to get the current ID value of Department table that use generated automatically . step 2: Now Insert value in Author table and get the Autoincremented id using the OUTPUt caluse. sing the Author_ID and Publisher_Id insert values in Book and Book_Author table...