CREATE PROCEDURE txt_Input
(@fileName varchar(200)--文件名
)
AS
declare @sql nvarchar(200)
set @sql='BULK INSERT dbo.TABLE1 FROM '+@fileName+
'WITH (
FIELDTERMINATOR='+'' ''+','+
'ROWTERMINATOR='+'\n'+')'
EXECUTE(@sql)GO
老是出错,对单引号一筹莫展,希望大虾给指导下,谢谢!!!
(@fileName varchar(200)--文件名
)
AS
declare @sql nvarchar(200)
set @sql='BULK INSERT dbo.TABLE1 FROM '+@fileName+
'WITH (
FIELDTERMINATOR='+'' ''+','+
'ROWTERMINATOR='+'\n'+')'
EXECUTE(@sql)GO
老是出错,对单引号一筹莫展,希望大虾给指导下,谢谢!!!
(@fileName varchar(200)--文件名
)
AS
declare @sql nvarchar(200)
set @sql='BULK INSERT dbo.TABLE1 FROM '+@fileName+
'WITH (
FIELDTERMINATOR='' '''+
'ROWTERMINATOR=''\n'')'
EXECUTE(@sql)GO
CREATE PROCEDURE txt_Input
(@fileName varchar(200)--文件名
)
AS
declare @sql nvarchar(200)
set @sql='BULK INSERT dbo.TABLE1 FROM '''+@fileName+
''' WITH (
FIELDTERMINATOR='' '',
ROWTERMINATOR=''\n'')'
EXECUTE(@sql)
GO
(@fileName varchar(200),--文件名
@terminator varchar(1)--分隔符
)
AS
declare @sql nvarchar(200)
set @sql='BULK INSERT dbo.TABLE1 FROM '''+@fileName+
''' WITH (
FIELDTERMINATOR=''' + @terminator + ''',
ROWTERMINATOR=''\n'')'
EXECUTE(@sql)
GO