为什么在以下代码中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.