CREATE TRIGGER MY_TRIGGER ON MY_TABLE
FOR INSERT AS

    DECLARE @myVariable;
    DECLARE InsertedRows CURSOR FAST_FORWARD FOR SELECT A_COLUMN FROM INSERTED;

    OPEN InsertedRows;
    FETCH NEXT FROM InsertedRows INTO @NewOrderCode;

    ...

        INSERT INTO ANOTHER_TABLE (
            CODE,
            DATE_INSERTED
        ) VALUES (
            @myVariable,
            GETDATE()
        );

    ...etc

CREATE TRIGGER ANOTHER_TRIGGER ON MY_TABLE
FOR INSERT AS

    UPDATE MY_TABLE
    SET A_COLUMN = something
    WHERE ID IN (SELECT ID FROM INSERTED);

...etc