SQL语句语法错误。

2012-10-30 02:54:15 174 阅读 AI 写同款 · GEO 优化AI 选题数据监测一键分发 ›

比较几款国际主流的电子元器件及物料清单管理软件 – 工具汇总 Arenasolution 老牌的基于云计算物料清单管理软件，bom.com就是他们家的，10天免费试用，功能被分成4个不同的产品, 和传统ERP功能上有重叠，偏向于物流生产规划，一定程度可以取代ERP的生产规划模块，平均价格70美元/月/席位。网页客户端，不支持离线 SiliconExpert 曾经的老牌物料清单管理软件，后被Arrow 收购，14天免费试用，功能被分成4个不同的产品阅读详情



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

提示"+"号附近有语法错误。

...全文

FastDDS之共享内存 transport层负责为DDS用户数据收发和服务发现提供通信。包含UDP，TCP，SHM。阅读详情

summerXJY100

C# 111,128 成员 642,537 内容

+ 关注 + 加入社区

切换为时间正序

luren66 2012-10-30

打赏
举报

create proc P_AAA
@server_ip varchar(50)
as
declare @sql varchar(100)
delete from t_backup
insert into t_backup select * from t_copy
delete from t_copy
set @sql = 'insert into t_copy(Sender_id) select top 5 * from opendatasource(''SQLOLEDB'', ''server='+@server_ip+';uid=sa;pwd=;database=KJ07'').KJ07.dbo.RegionReport order by Last_report_time desc'
exec(@sql)
select * from t_backup where Sender_id not in (select * from t_copy)
go

alan817 2012-10-30

打赏
举报

set @sql = 'select top 5 * from opendatasource(''SQLOLEDB'', ''server='+@server_ip+';uid=sa;pwd=;database=KJ07'').KJ07.dbo.RegionReport order by Last_report_time desc'
exec(@sql)

summerXJY100 2012-10-30

打赏
举报

[Quote=引用 1 楼的回复:]
把 ‘server=’+@p... 写到外面看
set @s ='server='+@p...

opendatasource('..', @s)
[/Quote]

改成下面的貌似还是不行



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

CoolKin9 2012-10-30

打赏
举报

select * from t_backup where Sender_id not in (select * from t_copy)
中Sender_id 与(select * from t_copy)中的*不匹配。
应该写作：
select * from t_backup where Sender_id not in (select Sender_id from t_copy)

wuyq11 2012-10-30

打赏
举报

insert into t_copy(Sender_id) select top 50 Sender_id from opendatasource('sqloledb','Data Source='+@provider+';uid=sa;pwd=;’).KJ07.dbo.RegionReport order by Last_report_time desc
看看

alan817 2012-10-30

打赏
举报

把 ‘server=’+@p... 写到外面看
set @s ='server='+@p...

opendatasource('..', @s)

SQL语句语法错误。

相关推荐