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