SQL(二) 将一张表数据插入另外一张表

INSERT INTO BaomingRelation
           ([BaomingID]
           ,[RelationNumber]
           ,[UserID]
           ,[Area])
     SELECT BaomingID,NEWID(),OperUserID,'bj' from Baoming
	where Area='bj'


 

原文地址:https://www.cnblogs.com/james1207/p/3339614.html