为什么在下面的代码中TRY没有捕获到该错误,如何捕获该错误?
BEGIN TRY
BULK INSERT [dbo].[tblABC]
FROM 'C:\temp.txt'
WITH (DATAFILETYPE = 'widechar',FIELDTERMINATOR = ';',ROWTERMINATOR = '\n')
END TRY
BEGIN CATCH
select error_message()
END CATCH
我刚得到这个:
Msg 4860, Level 16, State 1, Line 2
Cannot bulk load. The file "C:\temp.txt" does not exist.
这是一个有助于捕获此错误的选项:
BEGIN TRY
DECLARE @cmd varchar(1000)
SET @cmd = 'BULK INSERT [dbo].[tblABC]
FROM ''C:\temp.txt''
WITH (DATAFILETYPE = ''widechar'',FIELDTERMINATOR = '';'',ROWTERMINATOR = ''\n'')'
EXECUTE (@cmd)
END TRY
BEGIN CATCH
select error_message()
END CATCH
之后,我在CATCH中收到以下错误:
Cannot bulk load. The file "C:\temp.txt" does not exist.
本文收集自互联网,转载请注明来源。
如有侵权,请联系[email protected] 删除。
我来说两句