Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cmduser
Starting Member
3 Posts |
 Posted - 2011-05-15 : 08:53:07
|
| Please can you help me ,I have an exam with this question??Build a procedure that takes as argument a message according to the following XML format and adds the message 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></Order> |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2011-05-15 : 09:04:40
|
| Sorry, we don't answer exam questions on SQLTeam. You can find more information about XML methods in SQL Server Books Online, and via Google. |
 |
|
|
|
|
|
Procedure