insert data into two tables in a single query in sql server

You can't insert records in two tables through a single query, instead you can write a trigger on insert of first table to insert in second table.

hope it helps :)

Abhinav is correct, you probably do need a stored procedure - the alternative is to use a Transaction[^], where the data is not entered fully in either table until the transaction is complete, and can be rolled back if there is a problem. This would leave your database integrity ok.