22,209
社区成员
发帖
与我相关
我的任务
分享
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE InsJS
AS
BEGIN
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','222.190.111.117'
--go
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa','njemc51862371'
--go
select * from srv_lnk.njenvironment.dbo.监测点基本信息表
--go
exec sp_dropserver 'srv_lnk','droplogins'
--go
END
go
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE PROCEDURE InsJS
AS
BEGIN
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','IP'
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa','密码'
select * from srv_lnk.库.dbo.表
exec sp_dropserver 'srv_lnk','droplogins'
go
END
go