How to skip rows not in wellformed xml

Question

How to skip rows not in wellformed xml

Viewing post 1 (of 2 total)

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

Cadavre SSC-Forever Points: 41690 More actions · Answer 1

Only way I can think of would be to use a CLR. Do a try catch block to convert to XML, if it fails then return 0 if it passes then return 1. Then in your where clause, you'd have something like "WHERE dbo.myXMLCheck(myXMLCol) = 1".

Forever trying to learn
My blog - http://www.cadavre.co.uk/
For better, quicker answers on T-SQL questions, click on the following...http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better, quicker answers on SQL Server performance related questions, click on the following...http://www.sqlservercentral.com/articles/SQLServerCentral/66909/