How to insert data into two diffrent tables using sp in sql

Question

hi all,

 i want to insert data into two diffrent tables based on Id using stored procedure in sql server

please provide soultion regarding this,

 

Thanks