110,502
社区成员
发帖
与我相关
我的任务
分享
CREATE proc P_w
@provider varchar(20)
AS
delete from t_backup
insert into t_backup select * from t_copy
delete from t_copy
insert into t_copy(Sender_id) select top 50 Sender_id from opendatasource('sqloledb','server='+@provider+';uid=sa;pwd=;database=KJ07').KJ07.dbo.RegionReport order by Last_report_time desc
select * from t_backup where Sender_id not in (select * from t_copy)
GO
create proc P_AAA
@server_ip varchar(50),
@s varchar(100)
as
delete from t_backup
insert into t_backup select * from t_copy
delete from t_copy
set @s = 'server='+@server_ip+';uid=sa;pwd=;database=KJ07'
insert into t_copy(Sender_id) select top 5 Sender_id from opendatasource('sqloledb',@s).KJ07.dbo.RegionReport order by Last_report_time desc
select * from t_backup where Sender_id not in (select * from t_copy)
go