use SSBallDB insert into tb2 select * from master..tb2 waitfor delay '20:00:00'
试试这个,或许可以 SELECT a.id,a.[号 码],a.[No1],a.[No2],a.[No3],a.[No4],a.[No5],a.[No6],b.[R0],b.[R1],b.[R2],b.[R3],b.[R4],b.[R5],b.[R6] INTO [SSBallDB].[dbo].[1062数据总表] from [test].[dbo].[tb1] a left join [SSBallDB].[dbo].[1062分析总表] b ON a.ID =b.id order by a.ID
insert into [SSBallDB].[dbo].[TB2]
select * from [master].[dbo].[TB2]--或者select *
into [SSBallDB].[dbo].[TB2]
from [master].[dbo].[TB2]
insert into tb2
select * from master..tb2
SELECT * FROM [master].[dbo].[TB2]
如果两个数据库不在同一个数据库服务器上:首先建一个数据库链接:(参见联机丛书)sp_addlinkedserver [ @server= ] 'server' [ , [ @srvproduct= ] 'product_name' ]
[ , [ @provider= ] 'provider_name' ]
[ , [ @datasrc= ] 'data_source' ]
[ , [ @location= ] 'location' ]
[ , [ @provstr= ] 'provider_string' ]
[ , [ @catalog= ] 'catalog' ] 再执行插入操作:INSERT INTO [SSBallDB].[dbo].[TB2]
SELECT * FROM [数据库链接名称].[master].[dbo].[TB2]
insert into tb2
select * from master..tb2 waitfor delay '20:00:00'
SELECT a.id,a.[号 码],a.[No1],a.[No2],a.[No3],a.[No4],a.[No5],a.[No6],b.[R0],b.[R1],b.[R2],b.[R3],b.[R4],b.[R5],b.[R6]
INTO [SSBallDB].[dbo].[1062数据总表]
from [test].[dbo].[tb1] a
left join [SSBallDB].[dbo].[1062分析总表] b ON a.ID =b.id order by a.ID