Options
70-431 Managing XML Data
sinistamunkey
Member Posts: 15 ■□□□□□□□□□
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
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
Just because you can... doesn't mean you should.
Next: 70-536 and then THE WORLD!
Next: 70-536 and then THE WORLD!
Comments
-
OptionsLukeQuake
Member Posts: 579 ■■■□□□□□□□
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) -
Optionssinistamunkey
Member Posts: 15 ■□□□□□□□□□
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
Just because you can... doesn't mean you should.
Next: 70-536 and then THE WORLD! -
Options
BeaverC32
Member Posts: 670 ■■■□□□□□□□
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).MCSE 2003, MCSA 2003, LPIC-1, MCP, MCTS: Vista Config, MCTS: SQL Server 2005, CCNA, A+, Network+, Server+, Security+, Linux+, BSCS (Information Systems) -
Optionsfcerha
Member Posts: 2 ■□□□□□□□□□
<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 -
OptionsBeaverC32
Member Posts: 670 ■■■□□□□□□□
FYI, errata for this book can be found here:
http://support.microsoft.com/kb/920926/en-usMCSE 2003, MCSA 2003, LPIC-1, MCP, MCTS: Vista Config, MCTS: SQL Server 2005, CCNA, A+, Network+, Server+, Security+, Linux+, BSCS (Information Systems)
