27,579
社区成员
发帖
与我相关
我的任务
分享
create proc proc_abcd (@date_from datetime,@date_to datetime )
as
if not exists(select 1 from sys.servers where name='RemoteServerName')
begin
exec sp_addlinkedserver 'RemoteServerName','', 'SQLOLEDB', '192.168.1.8'
exec sp_addlinkedsrvlogin 'RemoteServerName', 'false ',null, 'MyUserName', 'MyPassword'
end
insert into tableB
select * from [RemoteServerName].[DateBase1].[dbo].tableA as tba
where tba.[date] between @date_from and @date_to
exec proc_abcd @date1, @date2
create proc proc_abcd (@date_from datetime,@date_to datetime )
as
if not exists(select 1 from sys.servers where name='RemoteServerName')
begin
exec sp_addlinkedserver 'RemoteServerName','', 'SQLOLEDB', '192.168.1.8'
exec sp_addlinkedsrvlogin 'RemoteServerName', 'false ',null, 'MyUserName', 'MyPassword'
end
EXEC('insert into tableB
select * from [RemoteServerName].[DateBase1].[dbo].tableA as tba
where tba.[date] between '''+CONVERT(VARCHAR,@date_from)+''' and '''+CONVERT(VARCHAR,@date_to)+'''')
GO
create proc proc_abcd (@date_from datetime,@date_to datetime )
as
if not exists(select 1 from sys.servers where name='RemoteServerName')
begin
exec sp_addlinkedserver 'RemoteServerName','', 'SQLOLEDB', '192.168.1.8'
exec sp_addlinkedsrvlogin 'RemoteServerName', 'false ',null, 'MyUserName', 'MyPassword'
end
EXEC('
insert into tableB
select * from [RemoteServerName].[DateBase1].[dbo].tableA as tba
where tba.[date] between '''+@date_from+''' and '''+@date_to+'''')
GO
exec proc_abcd @date1, @date2
你这样试下