+ Reply to Thread
Results 1 to 7 of 7
  1. Junior Member
    Join Date
    Sep 2007
    Location
    Norwich, UK
    Posts
    15
    #1

    Default 70-431 Managing XML Data

    I am really having problems with Lessons 3 and 4 where you use the Microsoft.Data.SqlXML to perform queries on the XML data in the table.

    I have run the project and even gone to the point of rewriting the project myself and once I put some error catching on it I get :

    Schema: unknown SQL type 'XML' on 'Details'

    Has anyone else had this problem? or is it just me being a fool

    Thanks
    Reply With Quote Quote  

  2. SS -->
  3. Senior Member
    Join Date
    Mar 2006
    Location
    The Internet
    Posts
    586

    Certifications
    See Signature
    #2
    Hello mate!

    I trust that the studying is going well.

    I might be able to help you, try adding this line to your code:-

    DIV = Left + 1

    Regards,

    Luke

    (cya at work buddy)
    Reply With Quote Quote  

  4. Junior Member
    Join Date
    Sep 2007
    Location
    Norwich, UK
    Posts
    15
    #3
    Quote Originally Posted by LukeQuake
    Hello mate!

    I trust that the studying is going well.

    I might be able to help you, try adding this line to your code:-

    DIV = Left + 1

    Regards,

    Luke

    (cya at work buddy)
    If only I had thought of using the power of a div in SQL
    Reply With Quote Quote  

  5. Senior Member BeaverC32's Avatar
    Join Date
    May 2007
    Posts
    677

    Certifications
    See Signature
    #4
    Just an FYI, I believe the MSPress book goes WAY too much in depth for what you need to know for the exam.

    It is my understanding that you need to know:

    - When to use the XML datatype versus when to store XML in text format
    - Uses of the built-in XML functions such as query(), nodes(), value(), etc.
    - Indexing on XML

    Refer to either the Sybex study guide or exam cram...the MSPress book is complete overkill (not to mention very poorly explained).
    Reply With Quote Quote  

  6. Junior Member
    Join Date
    Oct 2007
    Posts
    2
    #5
    <I might be able to help you, try adding this line to your code:>
    <DIV = Left + 1 >

    Excuse me for coming in here. I have the same problem with 2 lessons on SQLXML.
    Where do you enter this code? In VS or in the XML Document? Or even somewhere else?
    It would be very helpful if you could post a few lines of code.

    Thank's

    Fredrik
    Reply With Quote Quote  

  7. Senior Member BeaverC32's Avatar
    Join Date
    May 2007
    Posts
    677

    Certifications
    See Signature
    #6
    FYI, errata for this book can be found here:
    http://support.microsoft.com/kb/920926/en-us
    Reply With Quote Quote  

  8. Junior Member
    Join Date
    Oct 2007
    Posts
    2
    #7
    Wow, thanx a lot!
    Reply With Quote Quote  

+ Reply to Thread

Social Networking & Bookmarks