--创建 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 |
--创建 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 |