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

Find more posts tagged with

Comments

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)

sinistamunkey

LukeQuake wrote:

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

BeaverC32

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).

fcerha

<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

BeaverC32

FYI, errata for this book can be found here:
http://support.microsoft.com/kb/920926/en-us

fcerha

Wow, thanx a lot!