Home Forums Programming XML if you're using typed xml in sql server 2008, does the xml you store need to have every node that's in the XSD? RE: if you're using typed xml in sql server 2008, does the xml you store need to have every node that's in the XSD?

  • November 27, 2012 at 1:08 pm

    #1562834

    Thanks for your reply.

    You're absolutely correct about required columns (minOccurs).

    I've been leaning toward the hybrid approach, viz., storing frequently used/searched fields as columns then using an xml column to persist the sparsely used fields.