Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

XML Schema Collections Expand / Collapse
Posted Tuesday, July 22, 2008 4:01 PM


Group: General Forum Members
Last Login: Tuesday, April 19, 2016 8:50 AM
Points: 455, Visits: 678
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


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.
Post #538882
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse