从一个数据表中插入数据到另一个数据表中

----------------------------从一个数据表中插入数据到另一个数据表中------------------------------

 
insert into [127.0.0.1].aaaa.dbo.bbbb(id, statuw, times, user, guanli, bumen, zhuangtai, biaoti, jieshushijian, 
      neirong, leixing)
(SELECT id, statuw, times, user, guanli, bumen, zhuangtai, biaoti, jieshushijian, 
      neirong, leixing
FROM bbbb
WHERE (leixing= 'E80EF2AE-3AA6-4EC0-8E32-3D62C16C493C')
)