create table mytable
(
id UNIQUEIDENTIFIER,
name NVARCHAR(255),
tran_status NVARCHAR(255)
);

ALTER PROCEDURE UpdateByXml
(
@XML ntext
)
AS

DECLARE @idoc INT
EXEC sp_xml_preparedocument @idoc OUTPUT,  @XML

BEGIN

DECLARE @t TABLE(
            [Name] NVARCHAR(255) NOT NULL,
            [tran_status] NVARCHAR(255) NOT NULL
        )

INSERT @t
    SELECT * FROM OPENXML(@idoc, '//item', 1)
        WITH (
            [Name] NVARCHAR(255) '@Name'
            , [tran_status] NVARCHAR(255) '@tran_status'
        ) a

        INSERT INTO mytable ([id], [name], [tran_status])
        SELECT
            NEWID()
            ,t.Name
            ,t.tran_status
        FROM @t t
END