Results 1 to 3 of 3
  1. #1
    Join Date
    Aug 2011
    Posts
    4

    Post Unanswered: School Assigment

    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>

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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
    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

  3. #3
    Join Date
    Aug 2011
    Posts
    4
    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>

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •