通过select方式添加到另一个表
1、代码
insert into table_one(dataGuid,question,answer
addTime,updateTime)
select twoGuid,question_test,answer_test,
getdate(),getdate() from table_two
通过select方式添加到另一个表
insert into table_one(dataGuid,question,answer
addTime,updateTime)
select twoGuid,question_test,answer_test,
getdate(),getdate() from table_two