将一张表数据插入另外一张表

https://www.cnblogs.com/james1207/p/3339614.html

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