SQL Server Concatenate Error with TSQL

u1ehiz5o 于 2023-10-15 发布在其他

关注(0)|答案(1)|浏览(115)

What is wrong with the following code?

BULK INSERT test
FROM 'myfile_'+ CONVERT(VARCHAR(20), GETDATE(), 112) + '.TXT'
    WITH
    (FIRSTROW = 2,
     FIELDTERMINATOR = '~',
     ROWTERMINATOR = '\n')

Thanks

sql-server

来源：https://stackoverflow.com/questions/11801961/concatenate-error-with-tsql

1条答案

按热度按时间

vc6uscn91#

You can't dynamically concatenate the date to the filename in the bulk insert statement...

If you want to do this, you'll have to build up the statement using dynamic Sql then execute it:

DECLARE @Sql NVARCHAR(MAX)
SET @Sql = 
'BULK INSERT test
FROM ''myfile_' + CONVERT(VARCHAR(20), GETDATE(), 112) + '.TXT''
    WITH
    (FIRSTROW = 2,
     FIELDTERMINATOR = ''~'',
     ROWTERMINATOR = ''\n'')'

EXEC(@Sql)

赞(0）回复(0）举报 2023-10-15

我来回答

SQL Server Concatenate Error with TSQL

1条答案

相关问题

热门标签

最新问答