SQL语法问题

lirong 2011-04-08 08:18:36

declare @fname varchar (200)

set @fname='11.dbf'
insert into
openrowset('MICROSOFT.JET.OLEDB.4.0'
,'dBase 5.0;DATABASE=d:\','select * from [aa.dbf]')
select a.ArchID,PostTime,DispNum from openrowset('SQLOLEDB' , '192.168.0.201' ;
'sa' ; 'sa8899' ,WSMS_Beta_Demo.dbo.HouseArch ) a,
openrowset('SQLOLEDB' , '192.168.0.201' ;
'sa' ; 'sa8899' ,WSMS_Beta_Demo.dbo.HouseData )b
where a.UserJoinID=b.UserJoinID
and year(PostTime)=year(Getdate()) and month(PostTime)=month(Getdate()) and day(PostTime)=day(Getdate())

我想把aa.dbf用变量传进去，，这语法要怎么写啊。

按我下面的写说语法出错，提示 '+' 附近有语法错误。
insert into
openrowset('MICROSOFT.JET.OLEDB.4.0'
,'dBase 5.0;DATABASE=d:\','select * from ['+@fname+']')
select a.ArchID,PostTime,DispNum from openrowset('SQLOLEDB' , '192.168.0.201' ;
'sa' ; 'sa8899' ,WSMS_Beta_Demo.dbo.HouseArch ) a,
openrowset('SQLOLEDB' , '192.168.0.201' ;
'sa' ; 'sa8899' ,WSMS_Beta_Demo.dbo.HouseData )b
where a.UserJoinID=b.UserJoinID
and year(PostTime)=year(Getdate()) and month(PostTime)=month(Getdate()) and day(PostTime)=day(Getdate())

...全文

111 3 打赏收藏转发到动态举报

写回复

用AI写文章

3 条回复

切换为时间正序

请发表友善的回复…

发表回复

cs_lb 2011-04-08

打赏
举报



declare @fname varchar (200)  





set @fname='11.dbf'   



exec

(

'insert into  

openrowset(''MICROSOFT.JET.OLEDB.4.0''

,''dBase 5.0;DATABASE=d:\'',''select * from ['+@fname+']'')

select a.ArchID,PostTime,DispNum from openrowset(''SQLOLEDB'' , ''192.168.0.201'' ;

''sa'' ; ''sa8899'' ,WSMS_Beta_Demo.dbo.HouseArch ) a,

openrowset(''SQLOLEDB'' , ''192.168.0.201'' ;

''sa'' ; ''sa8899'' ,WSMS_Beta_Demo.dbo.HouseData )b

where a.UserJoinID=b.UserJoinID  

and year(PostTime)=year(Getdate()) and month(PostTime)=month(Getdate()) and day(PostTime)=day(Getdate())'

)