SQL Server XML

  • Mike C

    SSC-Insane

    Points: 23224

    Comments posted to this topic are about the item SQL Server XML

  • Christian Buettner-167247

    SSChampion

    Points: 13729

    Nice one!

    And I also have a question: During execution of the batch, I get a warning:

    XML DTD has been stripped from one or more XML fragments. External subsets, if any, have been ignored.

    Do you know how this can be turned off?

    SET ANSI_WARNINGS OFF does not work here, but there might be some other setting.

    Thanks!

    Best Regards,

    Chris Büttner

  • steveb.

    SSC-Forever

    Points: 46733

    Nice Question !!

  • Andy sql

    SSCrazy Eights

    Points: 9369

    I third that.... nice question, plus a concise but comprehensive explanation. Thanks.

  • magarity kerns

    SSCrazy

    Points: 2765

    Dealing with XML in SS has been one of those things that looks really cool and I can think of several pet projects that could use it but I just haven't had time to learn it 🙁

  • Harit Gohel

    Ten Centuries

    Points: 1254

    Good one

  • Anipaul

    SSC-Insane

    Points: 24681

    Nice question...

  • rajankjohn

    SSCertifiable

    Points: 5061

    Good one!

  • WayneS

    SSC Guru

    Points: 95341

    Good question!

    But, even better, GREAT explanation of all of the answers. I wish that all of the QODs did the answers this way!

    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

  • Noffer

    SSC Eights!

    Points: 906

    Christian Buettner (7/9/2008)


    Nice one!

    And I also have a question: During execution of the batch, I get a warning:

    XML DTD has been stripped from one or more XML fragments. External subsets, if any, have been ignored.

    Do you know how this can be turned off?

    SET ANSI_WARNINGS OFF does not work here, but there might be some other setting.

    Thanks!

    Agreed, I got tricked into picking the wrong answer after looking at the warning. :unsure:

  • Bob Lee

    SSC Eights!

    Points: 861

    I got thrown off too.

    But I'll chime in with a "Nice Question" and a Better answer. Way to set the bar!:smooooth:

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

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