declare @mpath varchar(50)
set @mpath='d:\shbxsys\shbx'
select * From openrowset('MSDASQL','Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=d:\shbxsys\shbx','select * from x_zgjb')

如何把最后一句里面的d:\shbxsys\shbx 用上面的参数替代.

说明:最后一句可以正常运行

试试吧!
declare @mpath varchar(50),@con varchar(1024)
set @mpath='d:\shbxsys\shbx'
set @con='Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB='+@mpath
select * From openrowset('MSDASQL',@con,'select * from x_zgjb')

消息 102，级别 15，状态 1，第 4 行
'@con' 附近有语法错误。

不行

试试:select * From openrowset('MSDASQL',(@con),'select * from x_zgjb')
或者:
declare  @sql  varchar(1024)
set @sql='select * From openrowset(''MSDASQL'','+@con+',''select * from x_zgjb'') '
exec (@sql)

都试过了,不行的 查资料说 openrowset()不支持变量.

谢谢cnfarer

这几天忙的没上网，晚来了。试试这个行不行：
CREATE PROCEDURE x_zgjb
  as
  declare @mpath char(16),@cdh  char(1), @cph char(1),@cfh char(1),@cedur  varchar(512)
  set @mpath='d:\shbxsys\shbx'
  set @cdh=","
  set @cph="'"
  set @cedur= 'select * From openrowset('+@cph+'MSDASQL'+@cph+@cdh+@cph+
       'Driver=Microsoft Visual FoxPro Driver; SourceType=DBF;SourceDB='+
       @mpath+@cph+@cdh+@cph+'select * from x_zgjb'+@cph+')'
  begin tran
      exec @cedur
        if @@error<>0
           begin
           rollback tran
            return
           end
        else
  commit tran
 GO