SQL-如何使用存储过程复制具有新主键的行？

I have 7 tables - Company, Person, Person_Link, Address, Address_Link, Phone, Phone_Link. I would like to have a Stored Procedure which intakes parameter of comp_companyid, then it can duplicate all the rows in the 7 tables with new primary keys and foreign for each table.I have 7 tables - Company, Person, Person_Link,