Last post Oct 05, 2007 10:45 PM by neutrino
Oct 04, 2007 04:48 PM|neutrino|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 09:55 PM|Motley|LINK
You can write your own function to do this either through T-SQL (painful) or .NET.
Oct 05, 2007 10:45 PM|neutrino|LINK
I ended up doing it in .NET and wrote this method: