1、添加到表
insert into OrderEx_GongYi(RowGuid,OrderExId,[Type])select newid(),RowGuid,WorkItemTempleteDtailName from OrderEx
2、更新到表
一个表的结果更新到另一个表里,两表有关联
updatetest1 as a,test2 as b set a.app_id=b.app_id where a.keyword=b.keyword
insert into OrderEx_GongYi(RowGuid,OrderExId,[Type])select newid(),RowGuid,WorkItemTempleteDtailName from OrderEx
2、更新到表
一个表的结果更新到另一个表里,两表有关联
updatetest1 as a,test2 as b set a.app_id=b.app_id where a.keyword=b.keyword
转载于:https://www.cnblogs.com/sulong/p/4809180.html