create table [#tb_Clip]([Clip] [varchar](14))
declare @SQL varchar(500)
set @SQL = 'BULK INSERT [#tb_Clip] FROM ' + @FilePath + ' WITH ( ROWTERMINATOR = ''\n'')'
exec @SQL
declare @SQL varchar(500)
set @SQL = 'BULK INSERT [#tb_Clip] FROM ' + @FilePath + ' WITH ( ROWTERMINATOR = ''\n'')'
exec @SQL
名称 'BULK INSERT [#tb_Clip] FROM 'E:\UpLoad\2004111560529645.txt' WITH ( ROWTERMINATOR = '\n')' 不是有效的标识符。
create table [#tb_Clip]([Clip] [varchar](14))
BULK INSERT [#tb_Clip] FROM 'E:\UpLoad\2004111560529645.txt'
WITH ( ROWTERMINATOR = '\n')
declare @SQL varchar(500)
set @SQL = 'BULK INSERT [#tb_Clip] FROM ''' + @FilePath + ''' WITH ( ROWTERMINATOR = ''\n'')'
exec(@SQL)