Home Forums Article Discussions Article Discussions by Author Discuss content posted by Wayne Sheffield Loading XML Data into SQL Server (SQL Spackle) RE: Loading XML Data into SQL Server (SQL Spackle)

  • January 3, 2011 at 11:58 am

    #1268609

    paul.marsh (1/3/2011)

    decent article - good reference. but I feel a comment about the bcp utility should be added for those situations that warrant a different approach.

    Paul - thanks. But how would you use BCP to load an XML file in? (This is what this article is about...)

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2