Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Oct 05, 2007 09:45 PM by neutrino
Oct 04, 2007 03:48 PM|LINK
I need to determine that a piece of XML in a character field or variable is well-formed XML. I need to store this validation result (valid or not valid flag) in the table.
Does SQL provide some function for this? Is there any other way?
Oct 04, 2007 08:55 PM|LINK
You can write your own function to do this either through T-SQL (painful) or .NET.
Oct 05, 2007 09:45 PM|LINK
I ended up doing it in .NET and wrote this method: