Table-Valued Function to Split Strings with Xml

  • Oscar D. Garcia

    SSC Eights!

    Points: 864

    Comments posted to this topic are about the item Table-Valued Function to Split Strings with Xml

    https://ozkary.com

  • WayneS

    SSC Guru

    Points: 95384

    There are some characters that are "special" to XML; if they are present in the string they will cause the string to not be converted into XML. If you're going to write a function for this, then you really need to include converting those characters is present so that it will still work.

    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

  • Siva Gurusamy

    SSCrazy

    Points: 2711

    Can you please elaborate Wayne.

    View Siva Gurusamy's profile on LinkedIn

    "Software changes. This is a rather obvious statement, but it is a fact that must be ever present in the minds of developers and architects. Although we tend to think of software development as chiefly an engineering exercise, the analogy breaks down very quickly. When was the last time someone asked the designers of the Empire State building to add ten new floors at the bottom, put a pool on the top, and have all of this done before Monday morning? " : Doug Purdy, Microsoft Corporation

  • akljfhnlaflkj

    SSC Guru

    Points: 76202

    Thanks for the script.

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

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