Post reply

SQL Server XML

  • July 8, 2008 at 11:02 pm

    #193538

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

  • July 9, 2008 at 12:52 am

    #839895

    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

  • July 9, 2008 at 3:16 am

    #839946

    Nice Question !!

  • July 9, 2008 at 4:34 am

    #839970

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

  • July 9, 2008 at 7:35 am

    #840128

    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 🙁

  • July 9, 2008 at 11:18 am

    #840400

    Good one

  • July 10, 2008 at 3:24 am

    #840695

    Nice question...

  • July 10, 2008 at 3:40 am

    #840699

    Good one!

  • July 10, 2008 at 6:31 am

    #840755

    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

  • July 10, 2008 at 1:27 pm

    #841080

    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:

  • July 18, 2008 at 11:55 am

    #845195

    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 10 (of 10 total)

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