sqlserver 两个数据库中表的结构不同，如何把一个表中的数据导入到另一个表中

insert into tableb..bb(b1,b2,b3) select a1,a2,a3 from tablea..aa

 

insert into 数据库1.a(id,name...)select id,name...from 数据库2.b

insert into tableb(b1,b2,b3) select a1,a2,a3 from[wjjj].[dbo].[fbase]

insert into tableb(b1,b2,b3) select a1,a2,a3 from[数据库2名].[dbo].[表]

 

实例

 

create database Testa
use Testa
create table Tablea
(
 id int primary key identity(1,1) not null,
 userName varchar(50) not null,
 pwd varchar(50) not null,
 age int not null
)
create database TestB
use TestB
create table Tableb
(
 id int primary key identity(1,1) not null,
 ageb int not null,
 pass varchar(50) not null
)

insert into Tableb(ageb,pass) select age,pwd from Testa.dbo.Tablea

insert into Tablea(age,pwd) select ageb,pass from TestB.dbo.Tableb