I am starting to work with xml data types and need to validate the data coming in. I need a best approach on how to store 2 different xml schema in one field. The schema's are close but not the same.
The table will look like this:
Schema type code schema xml
Box
Drum
I started down the validation process using schema collections but it looks like only one field can have one schema. That means I need a xml field for each type which does not make sense.
So I thought about using un-typed xml and using a stored procedure to validate the schema coming in. Can I do that? what is the best way to do this. Any help is gladly appreciated.