Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

XML Schema Collections Expand / Collapse
Author
Message
Posted Tuesday, July 22, 2008 4:01 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Monday, October 13, 2014 12:34 PM
Points: 424, Visits: 614
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.
Post #538882
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse