如何获取执行原生sql的错误信息?

Question

如何获取执行原生sql的错误信息

Answer 1

获取代码如下:

BEGIN TRY
SELECT 3 / 0
END TRY

BEGIN CATCH
DECLARE @errornumber INT
DECLARE @errorseverity INT

DECLARE @errorstate INT
DECLARE @errormessage NVARCHAR(4000)
SELECT
@errornumber = ERROR_NUMBER() ,
@errorseverity = ERROR_SEVERITY() ,

@errorstate = ERROR_STATE() ,
@errormessage = ERROR_MESSAGE()

SELECT @errornumber ,
@errorseverity ,
@errorstate ,

@errormessage

RAISERROR (
@errormessage, -- Message text,

@errorseverity, -- Severity,
@errorstate, -- State,
@errornumber

);
END CATCH