-
AppRuntimeVar設(shè)置
var.png - 存儲過程
[dbo].[p_GetDataFromHIS]
CREATE PROC [dbo].[p_GetDataFromHIS]
-- 1.創(chuàng)建遠(yuǎn)程鏈接服務(wù)器
EXEC sp_addlinkedserver 'server_link','','SQLOLEDB','遠(yuǎn)程服務(wù)器ip（如172.16.2.190）'
EXEC sp_addlinkedsrvlogin 'server_link','false',null,'遠(yuǎn)程數(shù)據(jù)庫用戶名（如sa）','遠(yuǎn)程數(shù)據(jù)庫密碼（如123456）'
GO
-- 2.追加插入數(shù)據(jù)
INSERT INTO HL7.dbo.Table1
SELECT *
FROM server_link.[HemoSystem].dbo.Table1 AS t
WHERE t.startDate
BETWEEN '2016-01-01 00:00:00.000'
AND '2016-02-01 00:00:00.000'
GO
-- 3.在[AppRuntimeVar]重設(shè)開始時間
UPDATE [HemoSystem].[dbo].[AppRuntimeVar]
SET Value = '2016-02-01 00:00:00.000'
WHERE KeyWord = 'starttime'
GO
-- 4.不再使用時刪除鏈接服務(wù)器
EXEC sp_dropserver 'server_link','droplogins'
GO
