alter procedure uptime
as
if not exists(select 1 from master.dbo.sysservers where srvname = 'srv_lnk')
begin
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','192.168.0.1 '
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa','123456'
end
declare @dat datetime
select @dat=/*从远端sqlserver上读来的系统时间*/
exec sp_dropserver 'srv_lnk','droplogins'select @dat
go
as
if not exists(select 1 from master.dbo.sysservers where srvname = 'srv_lnk')
begin
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','192.168.0.1 '
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa','123456'
end
declare @dat datetime
select @dat=/*从远端sqlserver上读来的系统时间*/
exec sp_dropserver 'srv_lnk','droplogins'select @dat
go
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货