How to insert data dynamically in different tables?

Question

Hi, I created dynamic survey. i want to copy the same survey to another survey id.

SurveyTable:

SID SName Created Date

QuestionTable

QID Question SID

AnswerOptionsTable

AID Answer QID 

Now i created one survey for that i added questions and answers. But i want to copy the same survey with another SName so that remaining table also changed accordingly.

Please provide a solution. Thanking you very much in advance. I asked my seniors also.

Answer 1

INSERT INTO SurveyTable ...
  SELECT ...
  FROM SurveyTable
  WHERE ...

Then capture the new row ID and do similar with the other two tables.