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

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