获取出错

1> DECLARE
2> @test_val INT;
3> BEGIN TRY
4> -- 导致一个除零错误
5> SET @test_val = 1024 / 0;
6> PRINT(STR(@test_val));
7> END TRY
8> BEGIN CATCH
9> PRINT('错误代码 = ' + STR(ERROR_NUMBER()));
10> PRINT('错误严重级别 = ' + STR(ERROR_SEVERITY()));
11> PRINT('错误状态代码 = ' + STR(ERROR_STATE()));
12> PRINT('错误信息 = ' + ERROR_MESSAGE());
13> END CATCH
14> go

来源:https://zhidao.baidu.com/question/494112667.html