CREATE PROCEDURE p_update_cj
@dbpath varchar(100),
@dbname varchar(20)
ASbegin
exec('
select * from openrowset(''MSDASQL'',
''Driver=Microsoft Visual FoxPro Driver;
SourceDB='+@dbpath+';
SourceType=DBF'',
''select * from '+@dbname+' where a_s=1'')
')
......end
@dbpath varchar(100),
@dbname varchar(20)
ASbegin
exec('
select * from openrowset(''MSDASQL'',
''Driver=Microsoft Visual FoxPro Driver;
SourceDB='+@dbpath+';
SourceType=DBF'',
''select * from '+@dbname+' where a_s=1'')
')
......end
不说这些了
问题已解决
结贴再次感谢 邹建