结构一样:
insert into dB2.dbo.TB2 select * from db1.dbo.TB1
结构不一样:
insert into dB2.dbo.TB2(a,b,c) select a,b,c from db1.dbo.TB1
例如:
insert into [citybird].[dbo].[jz_bigclassify]
([cdescription]
,[cname]
,[curl]
,[icon]) select cdescription,cname,curl,icon from [o2omarketdb].[dbo].[jz_BigClassify]