SQL 插入表 1 中表 2 中的多行，其中包含 Web 表单 C# 中的其他信息

我正在尝试通过 C# Web 窗体的按钮将数据从 Table1 插入到 Table2。我已经让它只将问题编号从表1附加到表2，但我无法弄清楚如何添加要从表单中添加的额外详细信息。（日期戳，用户）等

SqlConnection conn10000 = new SqlConnection(ConfigurationManager.ConnectionStrings["ESRConnectionString"].ConnectionString);
conn10000.Open();
string AppendQuestions = "INSERT INTO Table2 " +
                         " (StressQuestionNumber, StressQuestionnaireID, CreatedBy, CreateDate) VALUES( " +
                         "SELECT StressQuestionNumber " +
                         "FROM Table1, " +
                         "@StressQuestionnaireID, @CreatedBy, @CreateDate )";
SqlCommand com10000 = new SqlCommand(AppendQuestions, conn10000);
com10000.Parameters.AddWithValue("@StressQuestionnaireID", StressID);
com10000.Parameters.AddWithValue("@CreatedBy", Session["sesUserLogIn"]);
com10000.Parameters.AddWithValue("@CreateDate", DateTime.Now);
com10000.ExecuteScalar();
conn10000.Close();

INSERT INTO Table2 
(
 StressQuestionNumber, StressQuestionnaireID, CreatedBy, CreateDate
) 
 SELECT StressQuestionNumber, @StressQuestionnaireID, @CreatedBy, @CreateDate
   FROM Table1