declare @serverName varchar(20)
set @serverName='srv_lnk'
if exists(select 1 from master.dbo.sysservers where srvname=@serverName)
begin
EXEC sp_dropserver @serverName,'droplogins'
end
exec sp_addlinkedserver 'srv_lnk','','SQLOLEDB','192.168.45.34'
exec sp_addlinkedsrvlogin 'srv_lnk','false',null,'sa','Zxjc321'
go
insert into srv_lnk.monitorsystem.dbo.t_HistoryDataOriginal select * from monitorsystem.dbo.t_HistoryDataOriginal where IsUpload = 'N' and DataTime>=DATEADD(MONTH,-1,GETDATE())
update monitorsystem.dbo.t_HistoryDataOriginal set IsUpload='Y'where IsUpload='N'
go
exec sp_dropserver 'srv_lnk','droplogins'
数据库操作连接局域网中数据库
最新推荐文章于 2024-01-19 08:30:00 发布