We help IT Professionals succeed at work.

Understanding the XML object

juststeve asked
Medium Priority
Last Modified: 2012-05-06
I manage a CMS system via a .NET middle tier that blends conventional (non-xml) db fields with external XMLs. Currently, these files are hand edited.

Going forward, we need to implement code-based management of these files. Since I _could do all the things the system requires via .NET code I'm not _forced to undertake the learning curve involved with SQL's xml datatype right now. I _could use .net's xml tools to read the external file, allow the user edits, and save back to the file. But since non-xml parts of our content is stored in the db, it stands to reason that sooner or later we'll want to bring those external files into the db as well.

I guess I'm looking for an excuse to procrastinate the sql/xml learning curve or a kick in the butt to get in gear.

In that context....

Where's the best place to get a 'narrative' overview of how I would use the XML datatype to bring existing XML structures from files to the db?

Watch Question

Topic Advisor, Page Editor
Distinguished Expert 2018
There are a few good links and sites around. A lot of it depends on your level of experience, and seeing as you are XML savvy from a .NET code perspective, it makes it a little harder to find sites that capitalise on that background...

Anyway, have a look at : http://www.stylusstudio.com/sqlxml_tutorial.html

Then from the MS site : http://msdn.microsoft.com/en-us/library/ms345117.aspx  and http://msdn.microsoft.com/en-us/library/ms345115(SQL.90).aspx

Then there is the XML standards refernece for MS : http://msdn.microsoft.com/en-us/library/ms256177.aspx

And as an example of some specific content (note it is part 42) : http://www.databasejournal.com/features/mssql/article.php/3657691/SQL-Server-2005-Integration-Services---Part-42---XML-Task-continued.htm

Then if you like to click and find, there is the XML develoepr centre at MS : http://msdn.microsoft.com/en-us/xml/default.aspx  P.S. download XML notepad - tis good.

Not the solution you were looking for? Getting a personalized solution is easy.

Ask the Experts
Access more of Experts Exchange with a free account
Thanks for using Experts Exchange.

Create a free account to continue.

Limited access with a free account allows you to:

  • View three pieces of content (articles, solutions, posts, and videos)
  • Ask the experts questions (counted toward content limit)
  • Customize your dashboard and profile

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.


Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.