跨库查询

--创建链接服务器
exec sp_addlinkedserver 'ITSV ', ' ', 'SQLOLEDB ', '10.150.0.102'
exec sp_addlinkedsrvlogin 'ITSV ', 'false ',null, 'sa', 'sa@2003'
--查询示例
select * from ITSV.Tengbo.dbo.T_Role_Privilege as i
inner join T_Role_Privilege as t on t.ModuleNo=i.ModuleNo