Post reply

XML Files

  • June 20, 2007 at 2:15 am

    #172952

    All I'm new to XML and I'm looking for some help.

    I have received a file from the British Government in an XML format and I have not got the first idea how to read this file into an SQL Server 2000 database or even if it possible.  Can any one give guidance on any resources (Online, book) that I can use to learn how to handle this file.

    Thank you in advance

  • June 20, 2007 at 4:46 am

    #714056

    Hi Mark,

    Welcome to XM-HELL... Just kidding!

    Maybe.

    SQL Server is definitely capable of handling XML files. Start by having a look at XML-related pages (such as sp_xml_preparedocument and OPENXML) in Books Online.

    I bought this book when I started with XML and it helped immensely. http://www.amazon.co.uk/Professional-SQL-Server-XML-Programmer/dp/1861005466 (not an add for Amazon, it was just the bookmark I still have for it!)

    There's also a great article here on SSC entitled XML in 20 minutes by Leon Platt. They start at http://qa.sqlservercentral.com/columnists/lplatt/20010422115709_1.asp

    Well, you've got plenty of reading to do, so I'll leave you with that. Any questions just post them.


    Ade

    A Freudian Slip is when you say one thing and mean your mother.
    For detail-enriched answers, ask detail-enriched questions...[/url]

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply