一个存储过程有个参数 @FileAddress ,在 BULK INSERT InsertData FROM @FileAddress 这行中,提示我 :@FileAddress附近有语法错误,不知道如何写是正确的,请大家帮助,存储过程如下CREATE PROCEDURE dbo.sp_Zhoubin_InsertTable (
@FileAddress varchar(255) --文件路径
)
ASbegin
BULK INSERT InsertData FROM @FileAddress --问题就在这里
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
FIRE_TRIGGERS
)
end
GO
@FileAddress varchar(255) --文件路径
)
ASbegin
BULK INSERT InsertData FROM @FileAddress --问题就在这里
WITH
(
FIELDTERMINATOR = ',',
ROWTERMINATOR = '\n',
FIRE_TRIGGERS
)
end
GO
CREATE PROCEDURE dbo.sp_Zhoubin_InsertTable (
@FileAddress varchar(255) --文件路径
)
ASbegin
exec('
BULK INSERT InsertData FROM '+@FileAddress+'
WITH
(
FIELDTERMINATOR = '','',
ROWTERMINATOR = ''\n'',
FIRE_TRIGGERS
)
')end
GO
AS
BEGIN
declare @sql varchar(8000)
set @sql='
BULK INSERT InsertData FROM '''+@FileAddress+'''
WITH
(
FIELDTERMINATOR = '','',
ROWTERMINATOR = ''\n'',
FIRE_TRIGGERS
)'
exec(@sql)
END
GO
BULK INSERT InsertData FROM '+@FileAddress+'