我现在想把vf数据导入到sql数据库中,专门写了一个存储过程
我现在想采用动态create proc importdata
@filepath varchar(255)
as
select *
into shd
from openrowset('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB='+ @filepath, 'select * from [shd.DBF]') 可是编译总是不通过 提示+错误请高手指点怎么才能把这条语句根据我提供的路径,然后存储过程自动的导入本目录下面相应的表中的数据
我现在想采用动态create proc importdata
@filepath varchar(255)
as
select *
into shd
from openrowset('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB='+ @filepath, 'select * from [shd.DBF]') 可是编译总是不通过 提示+错误请高手指点怎么才能把这条语句根据我提供的路径,然后存储过程自动的导入本目录下面相应的表中的数据
into shd
from openrowset(''MSDASQL'', ''Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB='+ @filepath+''', ''select * from [shd.DBF]'')' )
SET @SQL = 'SELECT T.* INTO SHD
FROM OPENROWSET(''MSDASQL'', ''Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB='+ @filepath + ''',''select * from [shd.DBF]'') AS T'
EXEC @SQL
FROM OPENROWSET('MSDASQL', 'Driver=Microsoft Visual FoxPro Driver;SourceType=DBF;SourceDB=D:\data','select * from [shd.DBF]') AS T' 不是有效的标识符。