how to make stored procedure for inserting data in two tables
I am new in database technology.
I want to use stored procedure for inserting data in two tables using ASP.Net technology.
How can I do this using single SQL query?
below is the query for inserting in a single table.what should I add in this so that It can insert data in two tables?
String query = "INSERT INTO `zeestarretail`.`cash_memo_product` (`MemoID` ,`product_id` ,`MRP` ,`ptype` ,`p_percent` ,`p_disc` ,`rate` ,`qty` ,`itemname` ,`gross_disc_percent` ,`discount` ,`saleamount` )";
query += " VALUES (@maxProd, @prodid, @mrp, @ptype ,@p_percent ,@p_disc ,@rate ,@qty ,@itemname ,@gross_disc_percent ,@discount ,@saleamount)";