-- 获取远程数据库服务器的当前系统时间
-- create or alter
alter procedure p_linked_server_time
@linked_server varchar(50), -- 链接服务器名称
@server_time datetime output -- 服务器时间
with encryption
as
begin
-- 变量定义
declare @sql nvarchar(2000); -- SQL 语句
declare @parameter_def nvarchar(200); -- SQL 语句参数定义
if @linked_server is null or @linked_server = '' set @linked_server = '(local)';
set @sql = 'select @server_time = server_time from openquery([' + @linked_server + '], ''select getdate() as server_time'')';
set @parameter_def = N'@server_time datetime output';
exec sp_executesql @sql, @parameter_def, @server_time = @server_time output;
end