The statement that gets the error message code in the SQL Server Try...catch statement

This article is a detailed description of how to get the error message in SQL Server Try...catch statement code, specific examples such as, interested friends can refer to ha, I hope to help you copy the code is as follows:

BEGIN TRY
...
...
End TRY
BEGIN CATCH
DECLARE @ErrorMessage NVARCHAR (4000);
DECLARE @ErrorSeverity INT;
DECLARE @ErrorState INT;

SELECT
@ErrorMessage = Error_message (),
@ErrorSeverity = Error_severity (),
@ErrorState = Error_state ();

RAISERROR (@ErrorMessage,--message text.
@ErrorSeverity,--Severity.
@ErrorState-State.
);
End CATCH;