Build a procedure that takes as argument an order to the following XML format and adds the order data in the respective tables.

<Order>

<OrderData OrderID="10248" OrderDate="1996-07-04T00:00:00" EmployeeID="5" CustomerID="VINET">

<OrderItem ProductID="11" Quantity="12" UnitPrice="14.0000" />

<OrderItem ProductID="42" Quantity="10" UnitPrice="9.8000" />

<OrderItem ProductID="72" Quantity="5" UnitPrice="34.8000" />

</OrderData>

Do you have the missing XML needed to ocomplete your schema?

What tools will you be using? What language does your teacher expect you to use to write the procedure?

What have you tried so far? (with a nod to healdem)

-PatP

I have just this question for home work,and how can i make this procedure,that we take at this result,on xml.
The procedure is to make on SLQ.

Build a procedure that takes as argument an order to the following XML format and adds the order data in the respective tables.

<Order>
<OrderData OrderID="10248" OrderDate="1996-07-04T00:00:00" EmployeeID="5" CustomerID="VINET">
<OrderItem ProductID="11" Quantity="12" UnitPrice="14.0000" />
<OrderItem ProductID="42" Quantity="10" UnitPrice="9.8000" />
<OrderItem ProductID="72" Quantity="5" UnitPrice="34.8000" />
</OrderData>