Post reply

XML schema collection confused

  • June 3, 2010 at 2:27 pm

    #236067

    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?

  • June 8, 2010 at 9:42 pm

    #1177777

    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.

    .

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply