--创建链接服务器
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','远程服务器名或ip地址'
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'用户名','密码'
go
select *
from t1
union all
select *
from srv_lnk.数据库名.dbo.t2
order by t1.时间
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','远程服务器名或ip地址'
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'用户名','密码'
go
select *
from t1
union all
select *
from srv_lnk.数据库名.dbo.t2
order by t1.时间
into #temp
from table1into #temp(col1,col2,coltime,)
select col1,col2,coltime,....
from linkservername.databasename.dbo.tablenameselect * from #temp
order by coltime