如何把A数据库里的表用sql语句添加到B数据库

如何把A数据库里的表用sql语句添加到B数据库

B数据库存在表
use B
go
insert into tablename
select * from A【.schema】.tablename

B数据库不存在表,用下面语句就省得建表了
use B
go
select * into tablename
from A【.schema】.tablename

schema系统默认的是dbo，可以根据自己的需要做修改

--==========同一服务器上跨数据库数据拷贝========== set identity_insert news on insert into [p35cn11-10].dbo.news(newsid,title,content,typeid,nfrom,dateandtime,hits,power,keywords,enabled,uploadfiles) select id,tit,content,ctype,comefrom,adtime,visitnum,power,keywords,enabled,uploadfiles from [p35cn3_26].dbo.article insert into b(a, b, c) select d,e,f from b; set identity_insert news off

insert into t seelct * from [数据库A名称].dbo.t where 这个语句在数据库B里面执行！

select A..table into B..table A B 数据表结构要一样

insert into bb select * from aa