insert into bd2.dbo.E(a,b,c) select d,e, f from bd.dbo.b
例如:
insert into 数据库名.框架名.表名(列名) select (列名) from 数据库名.框架名.表名 where 条件
例如:
insert into MyEmp.dbo.tjdjb(yybh)
select yybh
from MyCmd.dbo.tjdjb where djrq='2009-10-15' and yybh = '11'