Multiple Insert/update rows using xml

[prakash09]

Hi all,

I want to insert multiple row from xml file to table in database..
i am try this code to insert..

ALTER PROCEDURE sp_InsertByXML ( @strXML VARCHAR(4000) )

AS

BEGIN

DECLARE @intDocHandle int



--Create an internal representation of the XML document.

EXEC sp_xml_preparedocument @intDocHandle OUTPUT, @strXML



INSERT INTO Person ( PersonId, PersonName )

SELECT * FROM OPENXML(@intDocHandle,

'/PersonData/Person', 2)

WITH

( PersonId INT,

PersonName VARCHAR(100)

)



-- Remove the internal representation.

EXEC sp_xml_removedocument @intDocHandle



END


please any one help me to resolve this issue.

Regards,
Om