Is there a way to validate XML using T-SQL?

Question

I'm in the process of converting a varchar(8000) field to an xml field in MSSQL 2005. Many of the XML docs have small issues (example: degree symbol not encoded). Is there a better way to validate the XML than a Try/Catch process?

Maybe I could write a .NET Stored Procedure. What is the proper method to validate (or invalidate) an XML document in .NET?

Dónal · Accepted Answer · 2008-11-11 15:51:02Z

1

You could write a Stored Procedure in managed code. Here are some samples http://www.yukonxml.com/articles/sqlclr/

edited Nov 11, 2008 at 15:51

Dónal

188k177 gold badges590 silver badges851 bronze badges

answered Nov 11, 2008 at 15:18

Bruno Shine

1,0311 gold badge9 silver badges17 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

BuddyJoe · Accepted Answer · 2008-11-19 13:06:46Z

0

So far I think it is more simple (but brute) to use the Try/Catch method. The team I am working on hasn't really started using Managed Stored Procs yet.

answered Nov 19, 2008 at 13:06

BuddyJoe

71.4k115 gold badges302 silver badges476 bronze badges

Collectives™ on Stack Overflow

Is there a way to validate XML using T-SQL?

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related