sqlserver用sql语句创建链接服务器
时间:2022-03-13 23:30
--创建 exec sp_addlinkedserver ‘SHUA_LINK‘, ‘‘, ‘SQLOLEDB‘, ‘数据库IP‘ exec sp_addlinkedsrvlogin ‘SHUA_LINK‘, ‘false‘,null, ‘sa‘, ‘密码‘ --查询 select top 10 * from SHUA_LINK.shua.dbo.shua_member order by regtime desc