TSQL Rethrow Exception

2012-and-later.sql

BEGIN TRY
    ...
END TRY
BEGIN CATCH
    ROLLBACK TRANSACTION;
    THROW;
END CATCH

pre-2012.sql

BEGIN TRY
    ...
END TRY
BEGIN CATCH
    ROLLBACK TRANSACTION;
    DECLARE @ErrorMessage nvarchar(4000) = ERROR_MESSAGE(),
            @ErrorNumber int = ERROR_NUMBER(),
            @ErrorSeverity int = ERROR_SEVERITY(),
            @ErrorState int = ERROR_STATE(),
            @ErrorLine int = ERROR_LINE(),
            @ErrorProcedure nvarchar(200) = ISNULL(ERROR_PROCEDURE(), '-');
    SELECT @ErrorMessage = N'Error %d, Level %d, State %d, Procedure %s, Line %d, ' + 'Message: ' + @ErrorMessage;
    RAISERROR (@ErrorMessage, @ErrorSeverity, 1, @ErrorNumber, @ErrorSeverity, @ErrorState, @ErrorProcedure, @ErrorLine);
END CATCH