Software Technologies

CREATE PROCEDURE [usp_Customer_INS_By_XML]

@Customer_XML XML

AS

BEGIN

EXEC sp_xml_preparedocument @xmldoc OUTPUT, @Customer_XML

--OPEN XML example of inserting multiple customers into a Table.

INSERT INTO CUSTOMER

(

First_Name

Middle_Name

Last_Name

)

SELECT

First_Name

,Middle_Name

,Last_Name

FROM OPENXML (@xmldoc,
'/ArrayOfCustomers[1]/Customer',2)

WITH(

 First_Name VARCHAR(50)

,Middle_Name VARCHR(50)

,Last_Name VARCHAR(50)

)

EXEC sp_xml_removedocument @xmldoc

END