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 collection confused Expand / Collapse
Author
Message
Posted Thursday, June 3, 2010 2:27 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
If I have multiple xml schema's for one column call it "properties". Can i validate against all the schemas just to make sure it validates? I can do this in the SP using a table variable but thought I could use sys.sys to avoid that.
Also if I leave this as untyped can I still index the column?
Post #932422
Posted Tuesday, June 8, 2010 9:42 PM
SSC-Addicted

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

Group: General Forum Members
Last Login: Tuesday, December 24, 2013 4:42 AM
Points: 460, Visits: 2,523
When you have multiple schemas associated with a column, the validation will succeed if the value is good with any of the schemas in the schema collection.

You an index an untyped XML column.


.
Post #934367
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse