22,209
社区成员
发帖
与我相关
我的任务
分享
Bulk Insert TempTable FROM 'e:\123.csv' WITH(FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')
SET @ImpSQLstr= 'Bulk Insert #TempTable1 FROM '+ @FilePath +'; WITH (FIELDTERMINATOR ='','',ROWTERMINATOR = ''\n'')'
Exec (@ImpSQLstr)
ALTER PROC [dbo].ImportFile
@FilePath NVARCHAR(200)
AS
BEGIN
DECLARE @ImpSQLstr NVARCHAR(600)
--Bulk Insert TempTable FROM 'e:\IF8600M1.csv' WITH(FIELDTERMINATOR = ',', ROWTERMINATOR = '\n')
SET @ImpSQLstr= 'Bulk Insert TempTable FROM '+''''+ @FilePath+'''' +' WITH (FIELDTERMINATOR ='','',ROWTERMINATOR =''\n'')'
EXEC (@ImpSQLstr)
END
USE [data]
GO
DECLARE @return_value int
EXEC @return_value = [dbo].[ImportFile]
@FilePath = N'E:\IF8600M1.csv'
SELECT 'Return Value' = @return_value
GO
报错:
消息 102,级别 15,状态 1,第 1 行
'E:' 附近有语法错误。
(1 行受影响)CREATE PROC ImportData
@FilePath NVARCHAR(200)
AS
BEGIN
DECLARE @ImpSQLstr NVARCHAR(1000)
SET @ImpSQLstr= 'Bulk Insert #TempTable1 FROM '''+ @FilePath +'''; WITH (FIELDTERMINATOR ='','',ROWTERMINATOR =''\n'')'
EXEC (@ImpSQLstr)
END