I am wirting a stored procedure, which basically just has some SQL Statements. In one line I am Casting to XML and inserting. Everything works good, but if an un formatted XML comes in the whole SP fails. I want to know a mechanism where by I can control
this so what ever records are well formatted should pass through, and the ones that fail should be recorded in some other table something like Error table to just insert ID of the records that failed. Any suggestions. So end result is that SP should run successfully
for well formatted XML documents and record ID in some other table for Failed ones.
View Complete Post