I have been using the following code snippet for Oracle OCI (I needed to disable parallel processing in my version):

EXECUTE IMMEDIATE 'ALTER SESSION DISABLE PARALLEL DML';

DELETE FROM TABLENAME;

INSERT INTO 
    TABLENAME
SELECT
    *
FROM
    TABLENAME_STG
;

COMMIT;

EXCEPTION WHEN OTHERS THEN
    ROLLBACK;
    RAISE; 
END;

Is the following the equivalent in T-SQL or what changes should I make?

BEGIN TRY
    BEGIN TRAN
        DELETE FROM TABLENAME

        INSERT INTO 
            TABLENAME
        SELECT
            *
        FROM
            TABLENAME_STG
    COMMIT TRAN
END TRY
BEGIN CATCH
    IF(@@TRANCOUNT > 0)
        ROLLBACK TRAN;
    THROW;
END CATCH