测试代码:
DECLARE @a INT = 9,
@b INT
BEGIN TRY
BEGIN TRY
SET @a = @a / 0
END TRY
BEGIN CATCH
SET @b = 1
END CATCH
SELECT '内部第1个CATCH:' + Cast(@b AS VARCHAR(20))
BEGIN TRY
SET @a = @a / 0
END TRY
BEGIN CATCH
SET @b = @b + 5
END CATCH
SELECT '内部第2个CATCH:' + Cast(@b AS VARCHAR(20))
END TRY
BEGIN CATCH
SELECT '最外CATCH:' + Cast(@b AS VARCHAR(20))
END CATCH
可以发现,当嵌套TRY...CATCH时,如果里面的TRY...CATCH触发,并不会影响外部的,而且代码也不会停止执行。