Understanding the XML object

Posted on 2009-02-14
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?

Question by:juststeve
    1 Comment
    LVL 51

    Accepted Solution

    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 :

    Then from the MS site :  and

    Then there is the XML standards refernece for MS :

    And as an example of some specific content (note it is part 42) :

    Then if you like to click and find, there is the XML develoepr centre at MS :  P.S. download XML notepad - tis good.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    731 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now