SQL try catch transaction block template

sql-try-catch-transaction-block-template.sql

BEGIN TRY 
	BEGIN TRANSACTION
        -- DO STUFF
	ROLLBACK TRANSACTION --ROLLBACK  COMMIT 
END TRY
BEGIN CATCH
    IF @@TRANCOUNT > 0
    BEGIN
        ROLLBACK TRANSACTION
    END    
    DECLARE @ErrorMessage NVARCHAR(4000)
    DECLARE @ErrorSeverity INT
    DECLARE @ErrorState INT
    SELECT @ErrorMessage = ERROR_MESSAGE(), @ErrorSeverity = ERROR_SEVERITY(),@ErrorState = ERROR_STATE()    
    RAISERROR (@ErrorMessage, @ErrorSeverity, @ErrorState)
END CATCH