sqlserver跨服务器查询数据sql语句记录
使用函数sp_addlinkedserver和sp_addlinkedsrvlogin。
exec sp_addlinkedserver 'ITSV', ' ', 'SQLOLEDB', '39.106.138.111'
exec sp_addlinkedsrvlogin 'ITSV', 'false ',null, 'hljyb', 'hljyb2222'
SELECT
*
FROM
IA_M_HSPOINT a
LEFT JOIN ITSV.SHYJ_DC_HLJ.dbo.IA_M_HSPOINT b ON a.HECD = b.HECD COLLATE Chinese_PRC_CS_AS and a.ELE = b.ELE
ORDER BY b.HECD