It depends on what you mean by "at once". Consecutive queries are likely to lead to fewer errors and better error handling, in one block of code. Otherwise try running in one stored procedure.
You can simply write a stored procedure which will help you to insert data into multiple tables at single point on time. If this is not what you are expecting then please be more elaborative in your question.
40
