how to write stored procedure to insert values into two tables?

Question

hi
how to write a single stored procedure to insert values into two tables at a time. columns are different in two tables. Please give a stored procedure, urgent please help me.
Thanks.