I'm working with typed xml in Sql server '05 and haven't been able to
resolve a couple questions through the documentation or any of my
searches so far - so fanfare aside here is the most immediate question:
If I have an XML Schema Collection with multiple namespaces how can
I specify an xml column or variable that only targets one of the
included namespaces?
i.e: (pretend this is SSMS)
- XML Schema Collections
----- dbo.FooSchema
--------- ns://mydomain.com/foo/
--------- ns://mydomain.com/importsFoo/
Is it possible to have a typed xml column/variable that is valid
only if the content conforms to the 'ns://mydomain.com/importsFoo/'
namespace?
Aside from this, if anyone has discovered any creative ways to
resolve an xs:import against a schema stored in a different collection
I'd love to hear about it.
In essence I have several namespaces under the same ns root and I
would like to use them in schema collections to validate and operate on
xml in the database, but I'm finding advanced support lacking. I'll
eventually become an expert on the topic through trial and error, but I
was hoping someone had already beat me to it.
So, any bytes?
Thanks;
Steve L.