EXEC jgmy.dbo.sp_addlinkedserver @server= N'192.168.100.230\JIAGONG', @srvproduct=N'SQL Server'
go
EXEC jgmy.dbo.sp_addlinkedsrvlogin @rmtsrvname = N'192.168.100.230\JIAGONG', @locallogin = N'sa',
@useself = N'False', @rmtuser = N'sa', @rmtpassword = N'password'
go
declare @ncount int
select @ncount=count(*) from [192.168.100.230\JIAGONG].[machining_trade].[dbo].[outmemo]
where corpid='c059'
print '远程数据库上有：'+cast(@ncount as char(10))+'条记录'
select @ncount=count(*) from outmemo
where corpid='c059'
print '本地数据库上有：'+cast(@ncount as char(10))+'条记录'
go
sp_dropserver '192.168.100.230\JIAGONG','droplogins'
go
sp_linkedservers
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。